469,364 Members | 2,424 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,364 developers. It's quick & easy.

Moving SQL Server 2005 databases

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

May 19 '07 #1
1 1507
(bo******@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 19 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by esmith2112 | last post: by
6 posts views Thread by Woody Splawn | last post: by
3 posts views Thread by datapro01 | last post: by
10 posts views Thread by amjad | last post: by
2 posts views Thread by Anns via SQLMonster.com | last post: by
3 posts views Thread by scoots987 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.