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.
ConceptsOverview of the Recovery Models
Performing File Restores (Full Recovery Model)
Overview of Restore and Recovery in SQL Server
Choosing the Recovery Model for a Database
Considerations for Switching from the Full or Bulk-Logged Recovery Model
Working with Transaction Log Backups
Minimally Logged Operations
Other ResourcesCreating Full and Differential Backups of a SQL Server Database
Restoring a Database to a Point Within a Backup
Help and InformationGetting SQL Server 2005 Assistance
17 July 2006