Microsoft® SQL Server® 2012 Bible

547 CHAPTER 21 Backup and Recovery Planning IN THIS CHAPTER Understanding the Recovery Models Backing up User Databases Understa ...

548 Part V: Enterprise Data Management Although backups tend to be boring, restores tend to occur when people are excited. For t ...

549 Chapter 21: Backup and Recovery Planning 21 ■ (^) Differential: Backup of all data pages modifi ed since the last full backu ...

550 Part V: Enterprise Data Management Recovery Model Description Transaction Atomicity Transaction Durability Bulk-Copy Operati ...

551 Chapter 21: Backup and Recovery Planning 21 FIGURE 21-1 A typical recovery plan using the simple recovery model includes onl ...

552 Part V: Enterprise Data Management The trade-off for this high level of transactional integrity is a certain amount of perfo ...

553 Chapter 21: Backup and Recovery Planning 21 If the disk subsystem containing the transaction log is lost, the database is ma ...

554 Part V: Enterprise Data Management operation is lost, and the restore must be made from the last transaction log. Therefore, ...

555 Chapter 21: Backup and Recovery Planning 21 You can determine the current recovery model for every database from the followi ...

556 Part V: Enterprise Data Management Best Practice You should back up the databases to a local disk (not the same disk where d ...

557 Chapter 21: Backup and Recovery Planning 21 FIGURE 21-3 The General page of the Back Up Database form. The backup source is ...

558 Part V: Enterprise Data Management The rest of the Back Up Database form specifi es the destination: ■ Name: The required na ...

559 Chapter 21: Backup and Recovery Planning 21 The Options page presents the following options: ■ Append to the Existing Backup ...

560 Part V: Enterprise Data Management Without all the options and frills, the most basic BACKUP command is as follows: BACKUP D ...

561 Chapter 21: Backup and Recovery Planning 21 BACKUP DATABASE AdventureWorks2012 TO DISK = 'e:\AdventureWorks2012Backup.bak' W ...

562 Part V: Enterprise Data Management Avoid using the MediaPassword option because this feature will be removed in the future r ...

563 Chapter 21: Backup and Recovery Planning 21 Working with the Transaction Log Sometimes it seems that the transaction log has ...

564 Part V: Enterprise Data Management Understanding logging and how it relates to recovery functions is critical for a successf ...

565 Chapter 21: Backup and Recovery Planning 21 ■ (^) A list of all active transactions ■ Information about the minimum work req ...

566 Part V: Enterprise Data Management If the data fi le of the user database and master database is damaged and the transaction ...