SQL Server 2000 and 2005 recovery models

SnapManager 2.1 for SQL Server supports all three types of SQL Server recovery models. See the following topics for more information:

Recovery models supported by SnapManager

SnapManager for SQL Server supports all three types of SQL Server recovery models:

SIMPLE
FULL
BULK_LOGGED

The SQL Server database administrator can assign each database a different recovery model, but specific recovery models are assigned to each database type by default.

SQL Server system database type	Default recovery model
master	SIMPLE
tempdb	SIMPLE
model	FULL
msdb	SIMPLE
distribution	FULL

The recovery model defines the fault tolerance level of your SQL Server environment. For more information about SQL Server recovery models, see the following resources:

The description of recovery model
Your Microsoft SQL Server documentation

Implications for SnapManager operations

The recovery model of an SQL Server database affects SnapManager operations, as described in the following paragraphs.

SIMPLE recovery model

When the SIMPLE recovery model is used, transaction logs cannot be backed up.

FULL recovery model

When the FULL recovery model is used, you can restore a database to its state at the point of failure. This entails the following sequence:

Back up the current active transaction log (if possible).
Restore the most recent database backup without recovery.
Restore each transaction log backup since the last restored backup.
Restore the transaction log backup of the currently active transaction log.
Note
If you want to do a fully recovery of the master database, deselect the Run transaction log backup after full database backup option below the Backup Management group for successful backup.

BULK_LOGGED recovery model

When the BULK_LOGGED recovery model is used, you need to manually redo bulk operations under the following circumstances:

Before you can perform a full database backup
Before you can perform a transaction log backup
If the database fails