Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 659
  • Last Modified:

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

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
Eric Sherman
Asked:
Eric Sherman
  • 2
2 Solutions
 
HoggZillaCommented:
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
 
Eric ShermanAccountant/DeveloperAuthor Commented:
Not an option HoggZilla ...  Yes, ver frustrating considering all I want to do is copy a database.

ET
0
 
Eric ShermanAccountant/DeveloperAuthor Commented:
I will re-open this question and re-structure the contents.

ET
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now