Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have four super small databases that I need to migrate from SQL Server 2005 on one box and move to a brand new SQL Server 2008 R2 box.

I have backed up the databases and copied them to the new machine.

Should I create the new databases and then restore the backups?

Should I restore the backups, creating them in the process?

Should I.....

What's the most reliable and easy way to set these databases up on my new machine?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

I've not had any problems with just leaping straight to the restore. Just remember that if any drive paths have changed (e.g. transaction logs on the new server are not stored in the same place that they were on the old server) you may need to edit the path as part of the restore process. But that's a 'detail', not a problem....

share|improve this answer
    
I'll give the first one a whirl right now. Thanks! –  Evik James Nov 13 '11 at 20:43
1  
Thanks. I did run into a few little snags, but I quickly worked my way out of them. Thanks for your input. –  Evik James Nov 13 '11 at 21:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.