Data Management

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)

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.

Read the rest of this entry. . .


Editor's Picks