Developing a Backup and Restore Plan
The key to success in backup and recovery is a good backup plan. Take the time to carefully map out the methods you will use to back up, and your procedures for restore. You will be glad you did if disaster strikes. Factors that will affect your backup plan will include:
The size of the database(s)
The media to which you backup (Tape or disk? Local or network?)
Database availability (9 to 5 or 7/24?)
How data is loaded (Weekly data load or OLTP?)
Your recovery window (How long will a restore take?)
After you have analyzed your backup needs, you can then implement a backup and recovery plan that is tailored to your environment. For instance, in a data warehouse populated by a weekly bulk load, it would be pointless ...
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.
