How Do I… Restore a SQL Server database to a new server?

How Do I… Restore a SQL Server database to a new server?

As a DBA, I have been in many situations where I had to move databases to a new server due to old hardware, failed hardware, failed drives, etc. You have two options you could use to carry out this task: SQL Server Management Studio (GUI) or T-SQL (Command line). The method I prefer is T-SQL. It is simple and easy and avoids clicking the mouse all over the screen. This How do I… will show you both methods and allow you to choose the one you prefer.

This download is also available as a Tech Republic blog entry and as a TechRepublic gallery.

Comments