sp_dbrecovery_order allows you to determine the order in which individual user databases recover. This makes it possible to assign a recovery order in which, for example, critical databases recover before lower-priority databases.
Important features of recovery order are:
System databases are recovered first, in this order:
master
sybsystemprocs
model
tempdb
sybsystemdb
sybsecurity
All other databases are considered user databases, and you can specify their recovery order.
You can use sp_dbrecovery_order to specify the recovery order of user-databases and to list the user-defined recovery order of an individual database or of all databases.
User databases that are not explicitly assigned a recovery order with sp_dbrecovery_order are recovered according to their database ID, after all the databases that have a user-defined recovery order.
If you do not use sp_dbrecovery_order to assign any databases a recovery order, user databases are recovered in order of database ID.
