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 ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond 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.
