O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required