Transaction Restore with Veeam Plug-in for Microsoft SQL Server

  • 3 November 2023
  • 2 comments
  • 185 views

Userlevel 7
Badge +6

 

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 plug-in, DBAs have complete control over the database backup and recovery processes, with zero friction with 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.

==============

  • SQL Server 2022 Evaluation Edition
  • SSMS versão 19.1
  • Database AdventureWorks 2022

Insert query:

SET IMPLICIT_TRANSACTIONS ON

use AdventureWorks2022

INSERT INTO [Person].[Person]

([BusinessEntityID], [FirstName], [MiddleName], [LastName], [PersonType])

VALUES

(20780, 'Angus', ' McKinnon', ' Young', 'SC')

GO

Insert into person.BusinessEntity(rowguid)

Values (newid())

SAVE TRANSACTION InsertStatement

select * from person.BusinessEntity

select * from person.Person

COMMIT TRANSACTION

Query to read the record:

use AdventureWorks2022

select BusinessEntityID, FirstName, LastName from [Person].[Person]

WHERE FirstName = 'Angus' AND LastName ='Young'


2 comments

Userlevel 7
Badge +21

This is such a cool feature with SQL. Going to look at it some more.  Thanks for sharing.

Userlevel 7
Badge +7

@leduardoserrano cool stuff, good to know.

Comment