Chapter 33 -- Restoring and Recovering the Database

3 4

Chapter 33

In Chapter 32, you learned the importance of backing up your system and how to perform those backups. This chapter continues our examination of database protection and builds upon the explanations presented in the previous chapter. You'll learn how to restore the database, how to plan for a disaster recovery, and you'll learn more about how database recovery works. As you'll see, the type of backup performed affects how recovery occurs. In addition to learning about restoring and recovering the database, you will be introduced to the concept of log shipping. Log shipping is new in Microsoft SQL Server 2000 and allows you to create a standby copy of your database on another server by using the original server's transaction log.

NOTE

---

Some DBAs refer to the process of restoring and then recovering the database as "recovering the database." However, these procedures are quite distinct. Chapter 32 explains the differences between restoring the database from backup and the SQL Server recovery process. In any case, bringing the database back to the state it was in at the point of failure is the main goal when backup, restore, and recovery operations are performed.