System Failures That Require Backups
To to help you better understand when and why backups are required, we will discuss specific types and examples of failures from which data can be restored only if there is a backup of the database. One assumption made in this section is that there is no disaster recovery site, a secondary datacenter to which all data is replicated so that it could take over in the event of failure at the primary datacenter. You might conclude that you can always use the disaster recovery site as a "backup" site if you keep it up-to-date, but you should still always create backups of your data in case even the disaster recovery systems incur any of the failures we discuss below as well.
Hardware Failures
As we’ve mentioned, you ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
