This is an archive version of the document. To get the most up-to-date information, see the current version.

Microsoft SQL Server Logs Backup and Restore

In this article

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.