Help Center
Choose product document...
Veeam Backup & Replication 9.5
User Guide for VMware vSphere

Microsoft SQL Server Logs Backup and Restore

To protect Microsoft SQL Server VMs, you can instruct the backup job to create image-level VM backups and periodically back up database transaction logs. If Microsoft SQL Server fails, you can restore the Microsoft SQL Server VM from the necessary restore point of the image-level backup. After that, you can use Veeam Explorer for Microsoft SQL Server to apply transaction logs and get databases on the Microsoft SQL Server to the necessary state between backups.

Requirements for Transaction Log Backup

  • Veeam Backup & Replication supports transaction log backups for the following systems:
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2014 SP2
  • Microsoft SQL Server 2012 SP3
  • Microsoft SQL Server 2008 R2 SP3
  • Microsoft SQL Server 2008 SP4
  • Microsoft SQL Server 2005 SP4
  • The database whose logs you want to back up must use the Full or Bulk-logged recovery model. In this case, all changes of the Microsoft SQL Server state will be written to transaction logs, and you will be able to replay transaction logs to restore the Microsoft SQL Server. You can use the Microsoft SQL Server Management Studio to switch to one of these models. For more information, see http://msdn.microsoft.com/en-us/library/ms189275.aspx.

Related Topics

Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Guide

Veeam Backup Explorers User Guide

PowerShell Reference

RESTful API Reference

Veeam Backup FREE Edition User Guide

Veeam Backup for Microsoft Office 365

Veeam ONE Documentation

Veeam Agent for Windows Documentation

Veeam Agent for Linux Documentation

Veeam Management Pack Documentation