3 4
This chapter completes our examination of database backup, restore, and recovery operations. In this chapter and the last chapter, you've learned how to effectively back up and restore a system and how SQL Server recovery works. You've seen how to perform these operations by using both Enterprise Manager and TSQL commands. This chapter focused on restore operations and on preparing a disaster recovery plan, a critical job. Remember, the security of the system is a major responsibility of the DBA.