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.
See Also
Concepts
Backup Under the Simple Recovery Model
Understanding How Restore and Recovery of Backups Work in SQL Server
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
17 July 2006 |
|