New SQL Server 2005 Video Tutorial: How to Move a Database Using Backup and Restore

How to Move a Database Using Backup and Restore - view details

This video tutorial shows you one technique for moving/copying a database from one server/instance to another using backup and recovery. There are many techniques for moving and copying databases and, if you haven't moved databases from server to server before, you'll want to be familiar with all techniques.

Highlights from this video:

• Taking and restoring backups
  
• Understanding the RESTORE DATABASE dialog box
  
• Resolving issues with restoring databases on other servers
  
• Discussion of orphaned logins
  
• Discussion of database compatibility and using sp_dbcmptlevel to view/change compatibility level
• How to view the SQL Server version in T-SQL
  

and much more

---

• Source: http://www.learnsqlserver.com
• Category: Database Creation, Management and Best Practices
• Skill Level: 200 (Beginner - Intermediate)
• Length: 9:15 (8.44MB)
• 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: backups, restores, disaster recovery