SQL Server 2005 Backup Information

SQL Server 2005 Database Architecture as it Relates to Backup and Recovery

Types of Failure

There are three main ways that your database can fail. Your job as SQL Server 2005 database administrator is to anticipate and plan for these inevitable database failures.

Recovery Models

Each database has its own recovery model which should be established during the design of the database. This section describes each model along with the advantages and disadvantages of each.

System Databases

SQL Server 2005 comes with many system databases. Find out which ones you need to be backing up, and which ones you don't need to worry about in this section.

Backup Types

There are a variety of different backup types available for SQL Server. Your organizational requirements help determine which backup types you should be using. Choosing a backup type means deciding on the right mix of recoverability and use of system resources. A database that is able to easily recover to a point of failure is more likely to use more system resources (disk space and processing power).

Database Files

The main categories of files in SQL Server are data files and transaction log files. These are discussed in depth along with subcategories for data files.

Memory

This section covers the buffer pool - an area in memory devoted to SQL Server.