Restore Restrictions Under the Simple Recovery Model
The simple recovery model imposes the following restrictions on restore operations:
- File restore and piecemeal restore are available only for read-only secondary filegroups. For information about these restore scenarios, see Performing File Restores (Simple Recovery Model) and Performing Piecemeal Restores.
- Page restore is not allowed.
- Point-in-time restore is not allowed.
If any of these restrictions are inappropriate for your recovery needs, we recommend that you consider using the full recovery model. For more information, see Backup Under the Full Recovery Model.
Help and Information
17 July 2006