Help Center
Choose product document...
Veeam Backup & Replication 9.0
Backup and Restore of SQL Server Databases

Detect Database Logging and Recovery Model

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.

Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Administrator Guide

Veeam Backup Explorers User Guide

Backup and Restore of SQL Server Databases

PowerShell Reference

RESTful API Reference

Veeam Direct Restore to Microsoft Azure

Veeam Backup FREE Edition User Guide

Veeam ONE Documentation

Veeam Endpoint Backup Documentation

Veeam Management Pack Documentation