O'Reilly logo

SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond by Tom Carpenter

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

Backing Up a Database

Unlike a typical operating system backup that can be performed only when major changes are made to an installation, your databases must be backed up regularly. The more heavily the databases are modified, the more frequently they must be updated. In this section, you'll see why you need backup and restoration plans. You'll also learn about recovery models, the different backup types, and how to perform the actual backups. If you abide by the recommendations in this section, your user data will be safe.

Creating a Backup Plan

An effective backup plan will include what data should be backed up, how it should be backed up, when it should occur, and how it will be restored in the event of an emergency. SQL Server provides 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