Back Up Microsoft SQL Server
To protect Microsoft SQL Server, you can use the Server edition of Veeam Agent for Microsoft Windows. You can set up the Veeam Agent backup job to create transactionally consistent backups of Microsoft SQL Server and periodically back up database transaction logs. If Microsoft SQL Server fails, you can restore the Microsoft SQL Server from the necessary restore point of the backup. If you use Veeam Agent for Microsoft Windows with Veeam Backup & Replication, you can also use Veeam Explorer for Microsoft SQL Server to apply transaction logs and get databases on the Microsoft SQL Server to the necessary state between backups.
This scenario describes how to set up the backup job to create transactionally consistent backups of Microsoft SQL Server. You will:
- Install a license for the Server edition of Veeam Agent for Microsoft Windows.
- Configure the backup job to create backups of the Microsoft SQL Server in the network shared folder.
To install a Veeam Agent for Microsoft Windows license:
- Double-click the Veeam Agent for Microsoft Windows icon in the system tray, or right-click the Veeam Agent for Microsoft Windows icon in the system tray and select Control Panel.
- From the main menu, select About.
- In the Version section, click the Update license to get additional features link.
Use Filters to Define File-Level Backup Scope
- At the Backup Cache step of the wizard, click Next.
- At the Guest Processing step of the wizard, make sure that the Enable application-aware processing check box is selected. Click Applications.
- In the Processing Settings window, click the SQL tab. Specify settings for database transaction log processing. Click OK, then click Next.
- At the Schedule step of the wizard, specify the day and time when the backup job must be started and configure advanced scheduling settings if necessary.
- Click Apply, then click Finish.