Transaction Restore with Veeam Plug-in for Microsoft SQL Server

Hey! Microsoft SQL Server backends some of the organizations’ most critical applications. Any loss of data or even the inability to fully recover this environment can cause catastrophic damage to the business.

Veeam offers several options to simultaneously protect the most business-critical applications and Microsoft SQL Server environments.

Starting with version 12 of Veeam Backup & Replication, the Veeam Plug-in for Microsoft SQL Server was made available.

This plug-in natively integrates with Microsoft SQL Server Management Studio, the Microsoft SQL Server management tool used by organizations’ DBAs (database administrators).

With this, DBAs now have complete control over the database backup and recovery processes, with zero friction in relation to their daily activities and an integrated manner with the organization’s data protection policy.

Therefore, the same Veeam platform protects virtual servers, Kubernetes clusters, physical servers, notebooks, desktops, and public cloud services.

Some differentiators of the Veeam Plug-in for Microsoft SQL Server:

• Simple and intuitive: only three buttons are added to the Microsoft SQL Server Management Studio menu;

• Scalability and performance: through the use of the SQL Virtual Device Interface (VDI), the plug-in supports up to 2,000 databases per SQL server and up to 10,000 databases per backup server;

• Scheduling full backups, differential backups, and transaction log backups using the tool’s native SQL Agent Job;

• With just a few clicks, it allows complete recovery or just specific database transactions;

• Integration with SQL Always-ON, protecting clusters or groups of servers;

• Backup of SQL backups, aiming for Disaster Recovery.

This video exemplifies a granular recovery operation the Veeam Plug-in for SQL provides to Microsoft SQL Server DBAs.