Solved

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

Posted on 2008-10-28
3
646 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
  • 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now