Free SQL Server 2005 Video Tutorial: How to Move a Database Using Detach and Attach

How to Move a Database Using Detach and Attach - download

Yet another way to move a database from one instance/server to another is to detach the database from the source and then attach the database to the destination (or to both the source and destination if you want to just copy the database).

Highlights from this video:

• When should I use detach/attach instead of backup/restore to copy/move my database to a new server?
  
• Best practices using detach/attach
  
• Detaching using SSMS and T-SQL
• Attaching using SSMS and T-SQL

and much more

---

• Source: http://www.learnsqlserver.com
• Category: SQL Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 10:30 (9.0MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: move drive, new servers