Support ID:

Phone: 1-800-848-6548

Website: Tivoli

Power Company

Phone:

Documentation and Media

You should always have a complete set of the following:

1. NT installation CD and any service packs
2. SQL Server installation CD and any service packs
3. Current ERD
4. Registry backup
5. Current version of any hardware drivers
6. A hard and soft copy output of sysdatabases, sysfiles, and sysfilegroups
7. A hard and soft copy of sp_configure

Appendicies

Any additional pertinent information should be stored here. This can contain network diagrams, server diagrams, scripts, etc. I normally attach a Powerpoint presentation and/or Visio diagram to my disaster recovery plans. The Powerpoint presentation is for a database diagram which lists the way the databases are allocated on the server. The Visio diagram normally depicts my server environment and network diagram.

The scripts that get included in this section are any custom scripts that are being used to generate portions of the recovery process. A good example is a script generator that I utilize on SQL Server 6.5 servers. This is a script written by Sharon Dooley that generates disk init statements for use in reconstructing your environment. The script can be found in the SQL Server script library located at http://www.swynk.com.

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