SQL Server 2000 Backup Information

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

Overview

This section describes the key database components that you need to know to craft a working disaster recovery plan for SQL Server 2000.

Types of Failure

There are only really three types of failure that you're likely to encounter as a DBA. This section describes each type of dire event the DBA must be prepared to recover from.

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.

Backup Types

This section describes the system databases that come with an installation of SQL Server 2000. It describes which should be backed up and which ones you don't have to worry about.

Database Files

The two main types of files in a database - data files and transaction logs - are described within this section.

Memory

The two main components of memory that you memory that you as a DBA need to be concerned with are presented within this section.

Configuration

SQL Server 2000 can be disaster resistant by following a physical architecture similar to the one presented in this section.

Troubleshooting

This section is extremely important. When you do have a failure, it is best to not panic and go about identifying all the issues you face in a systematic method. This section describes common troubleshooting techniques that should be performed to diagnose a problem with the database.

msdb tables

The msdb database has many interesting tables in SQL Server 2000 that can assist with backup and recovery. They are explained within this section.

Links

Links for SQL Server 2000 are presented within this section.