Veeam Plugin for Microsoft SQL

veeam-plugin-for-microsoft-sql-01

Veeam Plugin for Microsoft SQL is a backup tool for MS-SQL databases used to transfer Database and Transaction Log backups to Backup Repositories configured in Veeam Backup & Replication.

The Veeam Plugin leverages the native application-level backups of Microsoft SQL Server allowing to backup and restore individual MS-SQL databases with independent backup schedule for full, differential and log backups (SQL Agent Job required).

 

Prerequisites

Veeam Plugin for Microsoft SQL supports the following versions:

  • Supported Microsoft SQL Server versions: 2014 SP3, 2016, 2017, 2019, 2022
  • Microsoft SQL Server Express is not supported.
  • Windows Server Failover Clusters are supported.
  • Always On Availability Groups, Always On Clusterless Availability Groups and Always On Failover Cluster Instances are supported.

It also required to install Microsoft SQL Server Management Studio (SSMS):

  • SSMS v19.x must be installed if Veeam v12.1 is used.
  • SSMS v18.x must be installed if an earlier version of Veeam is used.

 

Install Veeam Plugin for Microsoft SQL

Copy from the Plugins folder located in the Veeam installer ISO file the VeeamPluginforMSSQL.exe file to the SQL Server.

veeam-plugin-for-microsoft-sql-02

Run the installer. Click Next to begin the installation of the Veeam Plugin for Microsoft SQL.

veeam plugin for microsoft sql 1

Click I Accept.

veeam plugin for microsoft sql 2

The plugin is being installed in the SQL Server.

veeam plugin for microsoft sql 3

When the installation has been completed, click Finish to exit the wizard.

veeam plugin for microsoft sql 4

 

When you open the Microsoft SQL Server Management Studio, you should find a new Veeam toolbar.

veeam plugin for microsoft sql 5

 

Configure the plugin

Before using the Veeam Plugin for Microsoft SQL, a minimal configuration is required.

 

Configure the Backup Repository

Click on the gear icon to configure the Veeam Backup Repository to store the database backups.

veeam plugin for microsoft sql 6

Enter the Veeam Backup Server and specify the credentials to access the backup server (make sure the account has the permissions to access the repository). Click Next.

veeam plugin for microsoft sql 7

Specify the Backup repository to use and click Finish.

veeam plugin for microsoft sql 8

Now click on the Backup database icon to configure the backup.

veeam plugin for microsoft sql 9

Select the Databases to backup, enter the Backup set name and select Full as Backup type. Click Next.

veeam plugin for microsoft sql 10

Configure the desired Retention and click Run to execute the Backup Job.

veeam plugin for microsoft sql 11

The selected database is being processed.

veeam plugin for microsoft sql 12

Looking at the configured Veeam Server, the SQL Backup Job is running.

veeam plugin for microsoft sql 13

After a few seconds the backup completes successfully. Click Close to close the window.

veeam plugin for microsoft sql 14

In the Veeam Backup Server a new Application Plug-ins group is now displayed.

veeam plugin for microsoft sql 15

The processed database is also available in the Backups > Disk section.

veeam plugin for microsoft sql 16

Unfortunately, this method doesn't provide the option to schedule the backup and the Edit option is greyed out.

veeam plugin for microsoft sql 17

 

Configure the Backup Job with SQL Agent

To schedule the Backup Job for both Database and Transaction Log, you need to configure the Veeam Plugin for Microsoft SQL job using the SQL Agent. Open the database backup configuration once again.

 

Configure Database backup

Specify the Databases to backup, Backup set name and select Full as Backup type. Click Next.

veeam plugin for microsoft sql 18

Configure the desired retention and click Save as a SQL Agent job.

veeam plugin for microsoft sql 19

Click Create.

veeam plugin for microsoft sql 20

Click OK.

veeam plugin for microsoft sql 21

 

Configure Transaction Log backup

Repeat the same procedure to configure the Log Backup Job. Specify the Databases to backup, Backup set name and select Log as Backup type. Click Next.

veeam plugin for microsoft sql 22

Click Save as a SQL Agent job.

veeam plugin for microsoft sql 23

Click Create.

veeam plugin for microsoft sql 24

Click OK.

veeam plugin for microsoft sql 25

 

Schedule the backup

In the left side of the SSMS, right click the SQL Server Agent (Agent XPs disabled) item and select Start.

veeam plugin for microsoft sql 26

Click Yes to start the Agent.

veeam plugin for microsoft sql 27

Expand SQL Server Agent and Jobs sections. Here you can find the configured SQL Backup Jobs.

veeam plugin for microsoft sql 28

 

Schedule a database Backup Job

Right click the configured DB Backup Job (Veeam_moviescatalog-backup in the example) and select Properties.

veeam plugin for microsoft sql 29

Select Schedules and click New.

veeam plugin for microsoft sql 30

Enter a Name and specify the desired schedule. Click OK to save the configuration.

veeam plugin for microsoft sql 31

Click OK.

veeam plugin for microsoft sql 32

 

Schedule a Transaction Log Backup Job

Repeat the same procedure for the Log backup. Right click the configured Transaction Log Backup Job (Veeam_moviescatalog-log in the example) and select Properties.

veeam plugin for microsoft sql 33

Select Schedules and click New.

veeam plugin for microsoft sql 34

Enter a Name and specify the desired schedule. Click OK to save the schedule.

veeam plugin for microsoft sql 35

Click OK.

veeam plugin for microsoft sql 36

 

Run the first backup

To avoid issues with the Transaction Log Backup Job if the configured RPO is very small, run the first Full backup manually. Right click the DB Backup Job and select Start Job at step.

veeam plugin for microsoft sql 37

The full backup is being executed.

veeam plugin for microsoft sql 38

The Backup Job in Veeam Backup & Replication.

veeam plugin for microsoft sql 39

Once configured, both Database and Transaction Log Backup Jobs will be executed on schedule.

 

Restore a database

From the Veeam toolbar, click the Restore database icon.

veeam plugin for microsoft sql 40

Specify SQL server name, Instance and the Databases to restore (MoviesCatalog in the example). Select the Backup Job that contains the database to restore and select the restore point to use. Click Next.

veeam plugin for microsoft sql 41

If it is requested to restore the database at specific point in time, select option Restore to any point in time (requires transaction logs backup). This option only works if we have Transaction Log backup configured.

veeam plugin for microsoft sql 42

Enter the Database name to use and click Run.

veeam plugin for microsoft sql 43

Click OK to proceed with the restore of the selected database. This operation will override the existing database.

veeam plugin for microsoft sql 44

 

Restore to a new database

Open the Restore Databases wizard. Select same options as done in previous steps but specify a different Database name in the Target section. Click Run.

veeam plugin for microsoft sql 45

The restore operation is being performed.

veeam plugin for microsoft sql 46

After a few seconds the database restore completes successfully. Click Close to close the window.

veeam plugin for microsoft sql 47

The new database is displayed in the SSMS.

veeam plugin for microsoft sql 48

Veeam Plugin for Microsoft SQL allows you to configure a lower RPO compared to snapshot-based backup limiting the data loss.

signature

Leave a Reply