The database inventory is obviously specific to your environment. This inventory gives a server by server breakdown of all databases. It should optionally provide a list of applications that access each database and sizing information. Below is a brief example.

Customer

Contains customer and contact information accessed by CustomerTracker, ContactManager, PROFILES (internal intranet application), PeopleSoft, CorpEIS with ad hoc access from Crystal Reports and PowerPlay.

Data = 150GB Log = 5GB

Orders

Contains order, payment, distribution, shipping, and inventory data accessed by Tracker, SAP, JDEdwards, IMS (Intercompany Mmanufacturing System)

Data = 200GB Log = 20GB

Backup Schedule

This comes from the backup plan you devised utlizing the information presented in this chapter. This gives a listing of when and how databases are backed up and what storage devices they are found on.

Backup Log

The backup log is your written record of all backups performed in your environment. This should be filled out every morning when verifying backups and also any time a backup is taken that is not in yoru normal schedule. This will list the day, server, database, and kind of backup taken. Download a template in Excel97 format.

Tape Rotation

This section will list the rotation plan for all backup tapes. This tells you what tapes are currently on site and which ones are stored offsite. You can then easily determine if a tape needs to be requested during a restore.

Recovery Situations

This section lists each situation that might require a restore and the exact steps to perform. This section will be expanded upon as SQL Server 7.0 becomes more widely deployed as some of the specific corruption situations that will require a restore will begin to be uncovered.

Backup Overview 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32