Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rogdawg
Starting Member
23 Posts |
 Posted - 2010-12-08 : 14:00:58
|
| On my SQL Server 2008 installation, when I attempt to copy a database, either to the same server, or to another server on the network, I get the following error:[364] The Messenger service has not been started - NetSend notifications will not be sentI have been able to copy databases from this server in the past. I am not sure how to solve this error. Where can I find the messenger service, to start debugging this?Thanks for any advice you can offer.On further inspection: When looking at the event logs for the SQL Server Agent, the error I reported above is from two days ago. I can't find an error for today's attempt to copy the database. The latest log file under SQL Server Agent is from 12/6/2010. There is a log file under SQL Server that is from today (12/8/2010) but there are no errors reported in it. If I look under Windows NT, there is an error description that just reads "Package "CDW_BLAHBLAHBLAH_5" failed. and that is it.Can anyone suggest a way to get started debugging this?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rogdawg
Starting Member
23 Posts |
Posted - 2010-12-08 : 15:57:23
|
| tkizer, Thank you for that great advice. I now have a copy of my production database placed onto a different server so I can test against it.I have been frustrated so many times by the copy functionality but, I never got the copy-using-backup-restore functionality quite right either, so I stopped trying to use it.I got it right this time.Thanks! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
error when trying to copy database