Problem Copying Database From Remote SQL Server to Local Server???
Posted on 2008-10-29
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 I'm tyring to use 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.
Also, in this setup, should I have the two servers linked or that is not necessary since I have connected two the two servers??
10/28/2008 21:13:43,,Error, The mail system failed to initialize; check configuration settings
10/28/2008 21:13:43,,Error, 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, The Messenger service has not been started - NetSend notifications will not be sent