Microsoft® SQL Server® 2012 Bible

567 Chapter 21: Backup and Recovery Planning 21 Truncating the Log Updates and deletes might not increase the size of a data fi ...

568 Part V: Enterprise Data Management Recovery Operations Many reasons exist to restore a database, including the following: ■ ...

569 Chapter 21: Backup and Recovery Planning 21 Recovery Sequences The two most important concepts about recovering a database a ...

570 Part V: Enterprise Data Management Performing the Restore with Management Studio As with the backup command, you can launch ...

571 Chapter 21: Backup and Recovery Planning 21 The Backup Sets to Restore option displays the available backups. Management Stu ...

572 Part V: Enterprise Data Management The Options page of the Restore Database form is shown in Figure 21-8. FIGURE 21-8 The Op ...

573 Chapter 21: Backup and Recovery Planning 21 ■ (^) The Restrict Access to the Restored Database option restricts access to th ...

574 Part V: Enterprise Data Management FIGURE 21-9 The Restore Page interface lets you check and see which database pages are ma ...

575 Chapter 21: Backup and Recovery Planning 21 The backupset table in msdb database contains a row for each backup set. You can ...

576 Part V: Enterprise Data Management The RECOVERY/NORECOVERY option is vital to the restore command. Every time a SQL Server s ...

577 Chapter 21: Backup and Recovery Planning 21 Go INSERT T1 VALUES ('Full'); go BACKUP DATABASE Plan2Recover TO DISK = 'e:\P2R. ...

578 Part V: Enterprise Data Management BACKUP LOG successfully processed 1 pages in 0.082 seconds (0.005 MB/sec). Continuing: SE ...

579 Chapter 21: Backup and Recovery Planning 21 Continuing: RESTORE LOG Plan2Recover FROM DISK = 'e:\P2R.bak' With FILE = 3, REC ...

580 Part V: Enterprise Data Management Be sure to back up the master database when doing any of the following: ■ Creating or del ...

581 Chapter 21: Backup and Recovery Planning 21 Run the following from the command prompt to start a default instance of SQL Se ...

582 Part V: Enterprise Data Management The msdb database is backed up in the same way that a user database is backed up. To rest ...

583 Chapter 21: Backup and Recovery Planning 21 Summary The recovery cycle begins with the backup of the databases. The ability ...

c21.indd 584c21.indd 584 7/31/2012 9:22:55 AM7/31/2012 9:22:55 AM http://www.it-ebooks.info ...

585 CHAPTER 22 Maintaining the Database IN THIS CHAPTER Using SQL Server’s Database Console Commands (DBCC) Creating Database Ma ...

586 Part V: Enterprise Data Management DBCC Commands Microsoft SQL Server Database Console Commands (DBCC) are used for checking ...