I am trying to use the Copy Database Wizard to copy all
the databases from one SQL Server to another, but I am
getting the following error after I select the destination
server and clicked next.
Error code:5510
Error category:5500
Source: Microsoft SQL-DMO
Description: [SQL-DMO]The name 'database name' was not
found in the databases collection. If the name is a
qualified name, use [] to separate various parts of the
name and try again.

Can anyone help to solve this issue?

Thanks.

I have seen this error in EM. My solution was to close and reopen it. Does
this work with DTS for you. Maybe recreate the task.?

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"D.A." <anonymous (AT) discussions (DOT) microsoft.com> wrote