Listing the User-Assigned Recovery Order of Databases

Use sp_dbrecovery_order to list the recovery order of all databases that are assigned a recovery order.

sp_dbrecovery_order generates output similar to:
The following databases have user specified recovery order:
Recovery Order Database Name        Database Id
-------------- -------------------- -----------
    1          dbccdb                   8
    2          pubs2                    5
    3          pubs3                    6
    4          pubtune                  7
The rest of the databases will be recovered in default database id order.

To display the recovery order of a specific database, enter the database name:

1> sp_dbrecovery_order pubs2
2> go
Database Name Database id Recovery Order
 ------------- ----------- --------------
 pubs2             5          2