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

Summary

Creating a backup plan and choosing a recovery model is an essential part of the DBA's role. You must have a plan that allows for recovery within business constraints. These business constraints may include short recovery windows and complete recoverability, and they will dictate the backup types you select. The recovery model is also important because it will determine how you can recover your databases. With the right recovery model and a solid backup plan, you can sleep peacefully at night knowing that your data is safe.

Backing up the SQL Server is one of the most important tasks the DBA must perform. In addition to the user databases, the system databases and the environment must be backed up. SQL Server supports three main types ...