This section describes how to recover the model database when it is the only database that needs to be restored.
Use dataserver to restore the model database without affecting master.
WARNING! Shut down Adaptive Server 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.
If you cannot use the database:
Issue the dataserver command described above.
If you have changed the size of model, reissue alter database.
Load the backup with load database.
If you have changed your model database, and you do not have a backup:
Issue the dataserver command described above.
Reissue all the commands you issued to change model.
