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