Copy Database Wizard for Log-shipping

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Copy Database Wizard for Log-shipping

Author

Topic

DB King
Starting Member

21 Posts

Posted - 2006-06-14 : 10:30:18

I am having a problem using the SQL Server 2000's Copy Database Wizard. After entering the source instance and the target instance I hit next and I get the following error message:

Error Code: 5510
Error Category: 5500
Source: Microsoft SQL-DMO
Description: [SQL-DMO]the name 'DATABASENAME' was not found in the Databases collection. If the name is qualified name, use [] to seperate various parts of the name, and try again

1) I have checked the databases and the DB quoted does exist ?
2) I cant understand why it errors before prompting the next screens which ask for the databases and the objects related to them ?
3) Is there an alternative to copy every object on one server to another server to prepare the other server for a resiliant partner using log-shipping ?
4) Where can I get a list of all SQL-DMO error codes ?
5) Where can I get a detail explaination of this error code with context to the DB it refers to - i.e. can i interrogate some event viewer or log file ?

SreenivasBora
Posting Yak Master

164 Posts

Posted - 2006-06-16 : 16:39:07

Check 2 things,

1. Verify the collation of both Servers & Databases are same are not?
2. Check both servers have same Service packs.

With Regards
BSR