prepare for disaster recovery of SQL 7.0
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
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
Make sure you are prepared to recover the entire
server, not just SQL.