Home / server / Questions / 330586
Accepted
Evik James
Asked: 2011-11-14 12:29:32 +0800 CST

SQL Server 2008 R2 - What is the best plan to back up 2005 dbs and move to new 2008 machine?

  • 772

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?

sql-server database

1 Answers

  1. Best Answer

    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....

    • 1