Fast, transaction-level recovery for SQL Server
Veeam® Explorer™ for Microsoft SQL Server gives you fast, transaction-level recovery of SQL databases. With agentless transaction log backup and replay1, you can quickly perform point-in-time restores of your Microsoft SQL Server databases — down to an individual transaction — achieving Recovery Time Objectives (RTOs) and Recovery Point Objectives (RPOs) of < 15 minutes.
With NEW Veeam Backup & Replication™ Community Edition, you can save a significant amount of time and restore local SQL databases without the need to search for individual files.
Easily restore Microsoft SQL Server databases
Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. It’s easy!
There’s no need to search for the location of the database and log files in a file-level recovery session or to spend time attaching restored files back to SQL Server — the entire process is fully automated. Select the SQL Server backup and click to:
- Restore databases to a specific point in time
- Restore to the same or different SQL Server
- Restore to original location with one click
- Export to a specified location and attach to a SQL Server later
The Enterprise Manager web interface even provides a complete view of all your available SQL databases to simplify the recovery of deleted or lost databases.
In Veeam Explorer for Microsoft SQL Server, you can export a database to its original location with one click. It can be exported as of the current restore point, to a certain point in time or to the state prior to a selected transaction. Moreover, based on your needs you can export a database to custom locations and attach it to any SQL Servers.
SQL Server backup and flexible recovery options
Veeam simplifies SQL Server recovery by providing you several options for restore. From a single image-level SQL backup, you can restore databases or tables1 and you don’t need to be an expert or know what MDF, NDF and LDF files mean — the wizard-driven recovery process will guide you through, detecting all available databases and instances that you can restore, but that’s not all:
- You can perform restore of multiple databases at once or all databases on a server
- If a database is too large to be restored in a timely manner, you can consider performing table-level recovery1 in scenarios when there are no dependencies between the restored and other existing tables
- You can run transaction log replay1 to perform quick point-in-time restores
Flexible options for your SQL backup needs and long-term strategy
SQL transaction log backup and replay1
Restoring a SQL database and ensuring low RTOs and RPOs has never been so easy! With agentless transaction log backup and replay, you can perform quick point-in-time restores up to a certain transaction, like rolling back the delete or insert query.
Transaction log backup is a separate option that can be triggered during SQL Server backup job configuration. It is complementary to the main image-level backup job and runs every 15 minutes (or less), taking incremental changes of the database. This enables granular, transaction-level recoveries for SQL databases.
Recovery is simple — just use the slider interface to identify whether you want to recover to a point in time or perform a more granular restore by entering a specific time, and in one click, you can recover your database.
Supported environments
The following versions of Microsoft SQL Server are supported as source/target systems for database restore:
- Microsoft SQL Server 2017 (only for Windows)
- Microsoft SQL Server 2016 SP2
- Microsoft SQL Server 2014 SP3
- Microsoft SQL Server 2012 SP4
- Microsoft SQL Server 2008 R2 SP3
- Microsoft SQL Server 2008 SP4
- Microsoft SQL Server 2005 SP4
All editions of Microsoft SQL Server are supported. Visit our release notes for more information.
