tailieunhanh - Microsoft SQL Server 2008 R2 Unleashed- P48

Microsoft SQL Server 2008 R2 Unleashed- P48:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 414 CHAPTER 14 Database Backup and Restore Backup and Restore Events AdventureWorks2008 on ZD8000 1NST2008 at 5 25 2009 10 25 07 AM Microsoft SQLServenoos This report provides historical data about Backup and Restore actions performed on the Database. g Average Time Taken For Backup Operations The average duration is calculated using the history of various types of backup operations performed on this database. Successful Backup Operations Shows details of the successful backup operations performed on this database in the past. Backup Operation Errors Shows detailsof the errors which caused the backup operations failure in the recent past. No backup operations errors occurred for AdventureWbrks2D08 database in the recent past or default trace is not enabled. Successful Restore Operations Shows details of the s uccessful restore operations performed on this database in the past. Date-Time Destination Restore Type Mode Recovery Option User Backup Name 5 252009 10 24 46 AM S AdventureWorks200B Log No replace Recovery ZD8000 Chris Destination Physical Files CAPrograrr FilesMicrosoft SQL ServertMSSQLIO INST20D8WSSQL DATA AdventureWorks2008_Log Idf 5 25 2DD9 10 24 45 AM E AdventureWbrks20D8 Log No replace No recovery ZD8000 Chris 5 25 2009 10 24 44 AM E AdventureWorks20D8 Log No repl ace No recovery ZD8000 Chris 5 25 2009 10 24 44 AM E AdventureWbrks2008 Log No replace No recovery ZDSOOOtChris 5252009 E AdventureWorks2008 Loa No real ace No recover1. ZD8000 Chris FIGURE Backup and Restore Events report. Restore Scenarios Restore scenarios are as varied as the backup scenarios that drive them. The number of scenarios is directly related to the types of backups taken and frequency of those backups. If a database is in simple recovery mode and full database backups are taken each night your restore options are limited. Conversely full recovery databases that have multiple filegroups and take a variety of different types of backups have a greater number of options that .