Hi Ronald,

If you want to migratie your database I believe that it is better to take a backup on you old system and then restore to your new system.
You can also detach your database and copy the physical files from the old to the new system. After the copy you can attach your database to the new system. Detach -> copy -> attach is faster than backup -> copy - > restore.

Greetz,

Peter De Cloet
Systeembeheerder

DEXIA Woonkredieten
B-8800 Roeselare
Belgium

* <mailto:peter.[Email address protected]
* <http://www.dexia.be/Private_nl/Credit/Transform.asp?XML=woonkredieten.xml&XSL=credit.xsl>
* +32 (0)51 23 21 91
* +32 (0)51 23 21 61



-----Original Message-----
From: Donald Bricker
[mailto:mssqldba-ezmlmshield-x6834378.[Email address protected]
Sent: dinsdag 30 november 2004 15:59
To: LazyDBA Discussion
Subject: _SUSPECT: 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]


MS Sql Server LazyDBA home page