How you can Backup SQL with Veeam
Veeam Backup permit to backup SQL Server. It’s possible to configure backup job for create image-level VM backups. This backup also permits copy database transaction logs. VM State captured. It’s possible to recover SQL Server with restore point and transaction logs. When backup job is configured, you must specify Advanced settings :
- How often transaction logs are saved
- The method of sending transactions to the destination
- Retention period of transaction logs
For backup database on SQL Server, it’s important to check that the recovery mode is configured on Full or Bulk-logged. If recovery mode is set to simple, Veeam Backup can’t detect and process transaction logs. For verify you can perform the following operations.
From the SQL Server, open SQL Management Studio and expand Databasenode.
Right click on the database and select Properties. Open Options tab and select Recovery model.
Create Backup Job
From Veeam console, open Home tab and click on Backup Job. Select Virtual machine on the menu.
A wizard appear, enter the name of the job and click on Next.
Click on Add and select VM backed up.
Select Backup Proxy and Backup repository and click on Advanced.
Configure backup mode as you want mode and click on OK.
On Guest Processing Window, enable application-aware processing check box. Specify user account to connect to the VM guest OS. This account must have Sysadmin right. Click on Applications button.
Select the desired VM and click on Edit.
A new Window appear, check Process transaction logs with this job option and select SQL tab.
Specify Backup logs periodically and Retain log backups. Click OK for validate modification.
Complete the wizard to create the backup job.
Restore SQL Database
Following the backup of a VM, it is possible to restore a SQL database. From the Veeam Backup & Replication console, open Home tab and expand Backups node. Click on Disk and select the server on the central panel.
In the ribbon, expand Application Items and select Microsoft SQL Server.
Select the restore point and click on Next.
Enter Reason and click on Next and on Finish. Veeam Explorer for Microsoft SQL Server started. Select the desired database and click on Restore.