Backup Strategy

Designing solid backup and restore strategies for each critical user and system database is very important for protecting your data. Backup types and backup schedules may be different for various databases and database servers. When planning a backup strategy, consider the following factors:

  • How critical is the data to the success of the business? Will you lose money if the data is lost or unavailable?

  • Is the data read-only or is it read-write? Read-only data may not need to be backed up more than once.

  • Is there an off-peak time when backups can be taken to minimize the performance overhead? For example, if users are not on the system during weekend nights, this might be a good time to perform full database backups.

  • How big is the ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.