Creating copies of the SQL 7.0 master and model databases

Use the following steps to create copies of the SQL 7.0 master and model databases.

To create copies of the SQL 7.0 master and model databases

  1. Use the SQL Server Service Manager to stop the SQL services.

  2. Open a command prompt window, and copy the original master and model databases and their transaction logs to the specified file names. In a default installation of SQL 7.0, the databases are in C:\MSSQL7\Data.

    Type the following:

    C:\ mssql7\data> copy master.mdf master$4idr
    C:\ mssql7\data> copy mastlog.ldf mastlog$4idr
    C:\ mssql7\data> copy model.mdf model$4idr
    C:\ mssql7\data> copy modellog.ldf modellog$4idr
    

More Information

Disaster recovery of SQL