Conclusion
In this chapter, you have seen the different backup types SQL Server provides. The combination and scheduling of these different types should form a backup strategy that meets your system performance and data integrity needs. These strategies range from simple models using only full database backups to full models using transaction log backups to provide the functionality to recover data right up to the time of data corruption.
Remember that a backup strategy should be planned, implemented, and tested for every database you have. Don’t wait to test your strategy until after data corruption has already occurred!
Chapter 3 Quick Reference
| To | Do this |
|---|---|
| Set the recovery model | Execute the SQL statement
USE master; GO ALTER DATABASE AdventureWorks ... |
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
