I agree the wizard could be usefull for "some tasks"

The problem was stated as migrate from old hardware to new, not the
things you pointed out.
I won't budge on my recommendation for the stated goal, the best way to
do this is backup/restore.

Everyone... Please let me know if you have had great success with moving
databases with the wizard.
I've seen many a "noobie" think they had a good copy, when in-fact they
did not !

If you restored, you have a 100% guarantee of the complete database
(yeah, you may have orphaned users... But no missing objects...)


Dano


-----Original Message-----
From: Mark Harr
[mailto:mssqldba-ezmlmshield-x62309305.[Email address protected]
Sent: Tuesday, November 30, 2004 3:07 PM
To: LazyDBA Discussion
Subject: RE: Problem with Copy Database Wizard [faked-from]
Importance: Low

Check you SQL Server Error logs, and the Event logs on both servers.
You should get a better description of what went wrong.


Dano/Peter;

There are times the Copy Database Wizard is useful. If you are moving
to a server with a different default collation or a different domain,
the wizard helps in converting properly. If you are just upgrading to a
bigger server, it is even easier to just detach the databases, copy
them, then attach them on the new server. Detach/Attach will also be
easier if you are moving files to a different location (drive or
directory).


======================
Mark Harr, MCSD, CPIM
Microsoft Solution Architect
Foresight Technology Group, A Berbee Company
EMail: mark.[Email address protected]


> -----Original Message-----
> From: Donald Bricker
> [mailto:mssqldba-ezmlmshield-x6834378.[Email address protected]
> Sent: Tuesday, November 30, 2004 9:59 AM
> To: LazyDBA Discussion
> Subject: Problem with Copy Database Wizard
>
> We have two Windows 2000 boxes with SQL Server 2000 loaded on both. We
> want to migrate a database from the old system to the new system. We
> have created a user on each of the systems with administrator
> rights to
> the box and sysadmin to the SQL Server. When we try to do the
> migration
> using the Copy Database Wizard it fails on the copying file step. It
> returns a generic error stating that The copy failed. There is no
> further explanation.
>
> Has anyone had a similar experience?
>
> Thanks
> Don Bricker
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page