Restore Under the Bulk-Logged Recovery Model
This topic discusses restore considerations that are unique to bulk-logged recovery model, which is intended exclusively as a supplement to the full recovery model.
For an introduction to the bulk-logged recovery model, see Backup Under the Bulk-Logged Recovery Model.
Generally, the bulk-logged recovery model is similar to the full recovery model, and the information described for the full recovery model also applies to both. However, point-in-time recovery and online restore are affected by the bulk-logged recovery model.
An online restore sequence works only if the following conditions are met:
All required log backups must have been taken before the restore sequence starts.
Bulk changes must be backed before starting the online restore sequence.
If bulk changes exist in the database, all files must be either online or defunct. (This means that it is no longer part of the database.)
If these conditions are not met, the online restore sequence fails.
We recommend switching to the full recovery model before starting an online restore. For more information, see Considerations for Switching from the Full or Bulk-Logged Recovery Model.
For information about how to perform an online restore, see Performing Online Restores.