Why Back Up Your Databases?
If you don't back up your databases, memorize this phrase: “Do you want fries with that?” It will come in handy in your new career.
In this age of reliable, redundant hardware the need for backups is often questioned. Unfortunately, redundant hardware only protects against the failure of that hardware. You can still experience data loss due to user or administrator error (yes, sooner or later even database gurus trash a database), corruption, malicious data destruction, or disasters such as fire. I like a backup plan that passes what I call the Scud Test. If a scud missile were to land in the server room, could you still restore the database? One sure way to answer yes to this question is to have valid backups, stored ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.
