第五章：sql灾难恢复讲解.ppt

Module 3: Disaster Recovery Course 6231A * On this slide, you will discuss the steps necessary to restore a transaction log. Walk the students through each of the restore steps. The process listed here is somewhat simplified and you can find more detail on the Student Companion CD or in the reference links below. The immediately previous full database backup or differential database backup must be restored first. All transaction logs created after the last full or differential backup must be restored in chronological order with no break in the chain of back ups and must specify WITH NORECOVERY with the except of the final log. With the final log backup indicate WITH RECOVERY to recover the database. Reference: For more information about restoring a transaction log, see “Restore Transaction Log”, /fwlink/?LinkID=127623 For more information about restoring a transaction log using SQL Server Management Studio, see “How to Restore a Transaction Log Backup (SQL Server Management Studio)”, /fwlink/?LinkID=127605 For more information about the different arguments for the RESTORE Transact-SQL statement, see “RESTORE Arguments (Transact-SQL)”, /fwlink/?LinkID=127622 Module 3: Disaster Recovery Course 6231A * In this demonstration, you will restore the backup created in the last demonstration. For this demonstration, perform the following tasks: Use the NY-SQL-01 Virtual Machine and logon as Student. Open SQL Server Management Studio and connect using Windows Authentication. Expand the database node. Right-click the AdventureWorks2008 Database, and then click Tasks | Restore | Database. On the General Tab: Under Destination for Restore, Ensure AdventureWorks2008 is selected as the destination database. Ensure “Point in Time” is set to Most Recent Possible. Under Source for Restore, Ensure From Database is selected. Ensure AdventureWorks2008 is the source database. Select the Restore checkbox on the most recently created backup set. Click the Options tab. Be sure to e