Moving SQL Server 2005 databases

What is the easiest way to move SQL Server 2005 databases from one old
server to a new server?

Re: Moving SQL Server 2005 databases

(bob66k88@gmail.com) writes:
> What is the easiest way to move SQL Server 2005 databases from one old
> server to a new server?

Personally I prefer BACKUP/RESTORE. This does not carry on logins,
you need to transfer them separately, and you will need to remap users
to logins on the new server. Then again, if the logins do not exist
on the new server you can create them with help of the WITH SID option.

You can also use the Copy Database Wizard, using the attach and detach
method. Note that it will take the database on the source server offline
while it copies the files. It also requires access to the disks of the
new and old server, to copy files. CDW will migrate logins for you.

CDW also offers the SMO method, where it copies the database by scripting
and bulking. But don't use this method, it's very unreliable, and may not
copy everything.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx