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.