Changing or Deleting the Recovery Position of a Database

To change the position of a database in a user-defined recovery sequence, delete the database from the recovery sequence, then insert it in the position you want it to occupy.

If the new position is not at the end of the recovery order, use the force option.

To delete a database from a recovery sequence, specify a recovery order of -1.

For example, to move the pubs2 database from recovery position 2 to recovery position 1, delete the database from the recovery sequence and then reassign it a recovery order as follows:

sp_dbrecovery_order pubs2, -1
sp_dbrecovery_order pubs2, 1, "force"