Recovering the model Database

Use dataserver to restore the model database without affecting master.

Warning!   Shut down SAP ASE before you use any dataserver command.
  • On UNIX platforms:
    dataserver -d /devname  -w model
  • On Windows:
    sqlsrvr -d physicalname -w model

If you can issue use model successfully, you can restore your model database from a backup with load database.

  1. Issue the dataserver command described above.
  2. If you have changed the size of model, reissue alter database.
  3. Load the backup with load database.
If you have changed your model database, and you do not have a backup:

  1. Issue the dataserver command described above.

  2. Reissue all the commands you issued to change model.

Parent topic: Restoring the System Databases