Restore Restrictions Under the Simple Recovery Model

The simple recovery model imposes the following restrictions on restore operations:

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


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: