April 30, 2008 at 9:21 am
Guys, little advise needed here....We are about to move all our databases from SQL 2000 to SQL 2005. There have been some confusion about which method to use here. Can somebody tell me the pros and cons of detach/attach over restoring from a backup.
Pretty urgent please!!!!
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
April 30, 2008 at 11:03 am
Detach / Attach will be faster because it does not have to do the restore part, but other than that the result will be exactly the same.
Make sure you update statistics after attaching or restoring.
April 30, 2008 at 12:49 pm
If your .mdf and .ldf are large but contain a small amount of data so the .bak file is much smaller, it could take longer to do detach\attach than backup \restore by the time you have copied files between servers\drives.
and the backup\restore leaves the dbs in place in 2000 in case you need to back out.
so it all depends on file sizes and what you feel comfortable with, both methods work.
---------------------------------------------------------------------
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply