Each time you restart Adaptive Server—for example, after a power failure, an operating system failure, or the use of the shutdown command—it automatically performs a set of recovery procedures on each database.
The recovery mechanism compares each database to its transaction log. If the log record for a particular change is more recent than the data page, the recovery mechanism reapplies the change from the transaction log. If a transaction was ongoing at the time of the failure, the recovery mechanism reverses all changes that were made by the transaction.
When you start Adaptive Server, it performs database recovery in this order:
Recovers master.
Recovers sybsystemprocs.
Recovers model.
Creates tempdb (by copying model).
Recovers sybsystemdb.
Recovers sybsecurity.
Recovers user databases, in order by sysdatabases.dbid, or according to the order specified by sp_dbrecovery_order. See “Recovery order.”
Users can log in to Adaptive Server as soon as the system databases have been recovered, but they cannot access other databases until they have been recovered.
The configuration variable print recovery information determines whether Adaptive Server displays detailed messages about each transaction on the console screen during recovery. By default, these messages do not appear. To display messages, use:
sp_configure "print recovery information", 1
