New Microsoft SQL Server Video Tutorial: Backup and Recovery - An Introduction to the Three Main Types of Backups in SQL Server 2000

Backup and Recovery - An Introduction to the Three Main Types of Backups in SQL Server 2000 - view details

Ahhhhh, backup and recovery - the "Bread and Butter" of every SQL Server DBA's life, right? This video is an excellent introduction to the different types of SQL Server backups - the full backup, the differential backup and the transaction log backup. EVERY administrator and developer should have a strong understanding of the types of backups in SQL Server 2000. Do you need to watch this video? Answer this question, "Which of the following backup types clear out the online transaction log (truncate the log) - full, differential, and/or transaction log backup?" Did you get the right answer? Oh - you don't know if you got the right answer? Then you're guessing and you should watch this video!

---

• Source: http://www.learnsqlserver.com
• Category: Disaster Recovery: Backup, Recovery, Log Shipping, Clustering and Database Mirroring
• Skill Level: 200 (Beginner - Intermediate)
• Length: 13:11 (8.22MB)
• Applies to Versions: SQL Server 2000
• 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: sql backup, sql server backup types, sql server transaction log backup