This chapter comes from our "SQL Server 2008 Database Administration" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Chapter 6: SQL Server Backup and Recovery

This chapter covers topics that every DBA needs to be well-versed in. In this chapter we'll cover the types of SQL Server backups and recovery models, how to develop an efficient backup strategy, and taking backups via SSMS and TSQL. We'll also discuss the fundamentals of restoring and work through restoring a database, collection of databases and an entire server.

Videos in Chapter 6

1Chapter Introduction and Setup of the Chapter Examples Download
2The Types of SQL Server Backups; Recovery Models Download
3The Simple and Full Recovery Models Download
4What are Bulk Operations in SQL Server? Download
5Transaction Log Architecture and the Bulk Logged Recovery Model Download
6How to Change the SQL Server Recovery Model Download
7The Basics of Restoring SQL Server Databases Download
8Developing Backup Strategies, Part 1 Download
9Developing Backup Strategies, Part 2 Download
10Example Restore Scenarios and Crash Procedures Download
11How Changing The Recovery Model Affects Backup Strategy Download
12Strategies with the FULL Recovery Model Download
13How Changing to BULK LOGGED Affects Your Risk Download
14A How-to Guide to Performing Bulk Operations Download
15How to Take Backups in SQL Server Management Studio (SSMS) Download
16How to Take Backups Using Transact-SQL, Part 1 Download
17How to Take Backups Using Transact-SQL, Part 2 Download
18Understanding How the Transaction Log Works, Part 1 Download
19Understanding How the Transaction Log Works, Part 2 Download
20What Happens When You Don't Backup the Log, Part 1 Download
21What Happens When You Don't Backup the Log, Part 2 Download
22Backup Devices Download
23Misc Bits: Backup Compression and Security Download
24Misc Bits: How to Turn On and View Backup Compression Download
25Misc Bits: NO_WAIT, ROLLBACK AFTER, ROLLBACK IMMEDIATE Download
26Misc Bits: Emergency! My Transaction Log Has Filled Up! Download
27Misc Bits: Taking a Backup of the Log without Clearing It Out Download
28Backing Up System Databases and Encryption Keys Download
29Where to Look for Problems: Error Logs Download
30Where to Look for Problems: Activity Monitor Download
31Where to Look for Problems: Default Traces Download
32Where to Look for Problems: The Dedicated Administrator Connection Download
33Reminders About the Restore Process Download
34The Fundamentals of Restoring Databases Download
35Performing Point in Time Restores Download
36How to Restore a SQL Server Database Using SSMS, Part 1 Download
37How to Restore a SQL Server Database Using SSMS, Part 2 Download
38How to Restore a SQL Server Database Using Transact-SQL Download
39Disaster Recovery: Restoring Your Entire SQL Server Download
40How to Rebuild Your SQL Server (a.k.a. Rebuild Master) Download
41How to Restore the Master Database Download
42How to Restore SQL Server System Databases, Part 1 Download
43How to Restore SQL Server System Databases,Part 2 Download
44How to Perform Use Emergency Mode and DBCC CHECKDB Download
Download this chapter

Browse this course's videos now