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

How to Move a Database Using Detach and Attach - view details

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: Database Creation, Management and Best Practices
• Skill Level: 200 (Beginner - Intermediate)
• Length: 10:30 (9.0MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

---

Keywords Associated with this video: move drive, new servers