Typically, automatic recovery takes from a few seconds to a few minutes per database. The time varies, depending 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 that period of time:
sp_configure "recovery interval in minutes"
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.