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.

4 comments
simon--
simon--

Every time I click through to the next page, I have to close half a screen of advertising :(

Azigyza
Azigyza

Hi, I am using incremental updated backups as part of my disaster recovery strategy. I have tested this against multiple scenarios and it works. M y question now is how do I restore all me databases from my backups incase the whole dell sever crushes.