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.
