Data Management

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

By Steven Warren

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)
  • 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 gallery is also available as a TechRepublic blog entry and as a TechRepublic download.