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

Restoring a Database to Specific Point in Time

This scenario allows you to recover your database to specific point in time (which may differ from current SQL Server restore point). Database will be recovered to the closest VM restore point before the moment you specify, and then transaction log replay will be performed on the target server to bring the database to the necessary state. So, to implement this scenario, ensure the following:

  1. SQL Server transaction logging is enabled - logging and recovery model must be set to full or bulk-logged.
  2. Transaction log handling in the SQL Server VM backup job settings had been configured to keep log backups: the Backup logs option should be selected.
  3. You have SQL Server application-aware backup created successfully.

In such a scenario you can also choose to restore to the original or different location.

Restoring a Database to Specific Point in Time Note:

  • Point- in-time restores from replicas and backups created with Backup Copy jobs are not supported)
  • Point-in-time-restores are not supported for Hyper-V VMs which were backed up with VSS copy_only option enabled.

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