Solved

Copy Database from Remote SQL Server to Local Server Problem???

Posted on 2008-10-28
3
654 Views
Last Modified: 2008-11-03
On a Windows Vista Home Premium system, I am trying to copy a database from a remote server to my local SQL server development machine.  I can connect to the two servers using SSMS and the Copy Database Wizard.  Once I complete all the Wizard screens and run the job I get the following error.  It has something to do with the Messenger Service for which is not installed on my Vista machine.  In the SQL Server Agent >>>> Alert System >>>> Mail Session, I have Enable Mail Profile Unchecked.  

Is there something else that needs to be done to disable the Alerts and mail session so the copy database job can successfully run???  I have the local server configured for local and remote connections and I can copy a local database.  It's only when I try to copy the database from the remote sql server.


10/28/2008 21:13:43,,Error,[355] The mail system failed to initialize; check configuration settings
10/28/2008 21:13:43,,Error,[260] Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database. ---> System.Data.SqlClient.SqlException: profile name is not valid<nl/>   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception<c/> Boolean breakConnection)<nl/>   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception<c/> Boolean breakConnection)<nl/>   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)<nl/>   a)
10/28/2008 21:13:43,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent


Thanks,

ET
0
Comment
Question by:Eric Sherman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 17

Assisted Solution

by:HoggZilla
HoggZilla earned 100 total points
ID: 22828273
I hate these kinds of errors, very frustrating. My thought is to start the copy database from the remote server, not locally. Is that an option?
0
 
LVL 19

Author Comment

by:Eric Sherman
ID: 22828312
Not an option HoggZilla ...  Yes, ver frustrating considering all I want to do is copy a database.

ET
0
 
LVL 19

Accepted Solution

by:
Eric Sherman earned 0 total points
ID: 22833356
I will re-open this question and re-structure the contents.

ET
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question