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	Changed content: Moved restore scenario summary into Overview of Restore and Recovery in SQL Server. Changed topic title from "restore scenarios under the simple recovery model" to Restore Restrictions Under the Simple Recovery Model.