Solved

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

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Help 27 45
SQL Server 2012 r2 - Varible Table 3 24
Query to capture 5 and 9 digit zip code? 4 21
Correct an issue with a where clause with calculation 2 31
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
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.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

809 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