To prepare for disaster recovery if using SQL 7.0, do the following:

• Create a copy of the master and model databases, and place the copies in the same directory that the databases are in.

  See “To create copies of the SQL 7.0 master and model databases”.

• Back up both system and user databases and transaction logs regularly.

• Back up the system drive that contains SQL.

  Backing up the system drive that SQL is on also backs up all the executables and registry settings needed for SQL to run.

• Back up the master database whenever any changes are made to SQL.

• Keep records of any service packs that have been installed.

• Make sure you are prepared to recover the entire server, not just SQL.