Solved

Problem Copying Database From Remote SQL Server to Local Server???

Posted on 2008-10-29
6
242 Views
Last Modified: 2012-08-14
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,[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
6 Comments
 
LVL 42

Accepted Solution

by:
EugeneZ earned 200 total points
Comment Utility
hmm
can you just backup->copy-> restore the database?
--
if not - make sure you have installed fresh sql server 2005 SP (at least 1)
also
run
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
 on your servers and post results

sp2
http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en

sp1
http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&displaylang=en
0
 
LVL 19

Author Comment

by:Eric Sherman
Comment Utility
>>>can you just backup->copy-> restore the database?<<<

That's what I was trying to do at first but when I backup the remote database  it will save the .bak file to the hard drive of the machine the remote server is running on.  I need to backup the remote server but save the .bak file on my local machine.

If I understand correctly, that cannot be done.  I think I will have to do it in 3 steps.

1.) Have the remote administrator backup the db creating the .bak file.
2.) Download or FTP this file to my local machine.
3.) Restore this file on my local SQL Server.

I was trying to do it all from this end and that's probably not possible.

Please advise ...

Thanks,

ET
0
 
LVL 38

Assisted Solution

by:Jim P.
Jim P. earned 200 total points
Comment Utility
I've used the copy DB wizard once. It really is total crap.

Your best bet is to do it the way you are thinking.
0
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)

 
LVL 26

Assisted Solution

by:Zberteoc
Zberteoc earned 100 total points
Comment Utility
Is the remote server on the same network with your local one? Does the remote server belong to a hosting provider and the only connection is through the internet?

These are different possible scenarios and they have different solutions.

If the server is accessible to you on the same network just make the backup to a network folder like \\networkfolder\ and restore from there.

If the remote is on a hosting location than the only way is to ask the admin to backup the database and make the bak file downloadable for you on a location.
0
 
LVL 19

Author Closing Comment

by:Eric Sherman
Comment Utility
Thanks All!!

I will use the Backup ---> Restore method since this seems to be more reliable.

ET
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
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…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

744 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

19 Experts available now in Live!

Get 1:1 Help Now