Typically, automatic recovery takes anywhere between a few seconds and a few minutes per database. The amount of time depends on the size of the database, the size of the transaction log, and the number and size of the transactions that must be committed or rolled back.
Use sp_configure with the recovery interval in minutes parameter to specify the maximum permissible recovery time. Adaptive Server runs automatic checkpoints often enough to recover the database within the period of time you specify.
The default value, 5, allows recovery within 5 minutes per database. To change the recovery interval to 3 minutes, use:
sp_configure "recovery interval in minutes", 3
The
recovery interval has no effect on long-running, minimally logged
transactions (such as create index) that are
active at the time Adaptive Server fails. It may take as much time
to reverse these transactions as it took to run them. To avoid lengthy
delays, dump each database immediately after you create an index
on one of its tables.
