This document is not supported any longer.

Detect Database Logging and Recovery Model

In this article

    SQL Server backup and restore processes go within the context of a database recovery model which defines the following:

    • What types of backups and what restore scenarios will be supported for the database
    • How the transaction log should be handled for that purpose

    Microsoft SQL Server supports several logging and recovery models for its databases: simple, full, and bulk-logged.

    • With simple recovery model specified for your database, you will be able to restore it only to the selected restore point; SQL Server will automatically truncate logs, and Veeam backup configuration will not affect any of them.
    • With other models (full and bulk-logged), database transaction logs will not be truncated automatically by SQL Server, and Veeam offers different processing options for them.

    To discover logging and recovery model for the database which you plan to backup and restore, use SQL Server Management Studio or contact your database administrator.

    Detect Database Logging and Recovery Model Note:

    To read more about different logging and recovery models, refer to the Recovery Models (SQL Server) MSDN article.
    To learn how transaction log truncation works, refer to the Transaction Log Truncation article.