This and subsequent sections describe application-aware processing of Microsoft SQL Server and Oracle database systems in Veeam Agent for Microsoft Windows. You can perform item-level recovery of Microsoft SQL Server and Oracle systems if you use Veeam Agent for Microsoft Windows with Veeam Backup & Replication. For more information, refer to the Veeam Backup & Replication documentation at: https://www.veeam.com/documentation-guides-datasheets.html.
Microsoft SQL Server Log Backup
You can instruct the Veeam Agent backup job to create volume level or file-level backups and also periodically back up database transaction logs. If Microsoft SQL Server fails, you can restore Microsoft SQL Server from the necessary restore point of the Veeam Agent 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.
Requirements for Microsoft SQL Server Transaction Log Backup
- Veeam Agent for Microsoft Windows supports transaction log backups for the following systems:
- Microsoft SQL Server 2017
- Microsoft SQL Server 2016
- Microsoft SQL Server 2014 SP2
- Microsoft SQL Server 2012 SP3
- Microsoft SQL Server 2008 R2 SP3
- Microsoft SQL Server 2008 SP4
- The database whose logs you want to back up must use the Full or Bulk-logged recovery model. In this case, all changes of the Microsoft SQL Server state will be written to transaction logs, and you will be able to replay transaction logs to restore the Microsoft SQL Server. You can use the Microsoft SQL Server Management Studio to switch to one of these models. For more information, see this Microsoft KB article.
Oracle Log Backup
Veeam Agent for Microsoft Windows supports backup of Oracle database archived logs. If you use Veeam Agent for Microsoft Windows with Veeam Backup & Replication, you can use Veeam Explorer for Oracle to apply archived logs and get Oracle databases to the necessary state between backups.
Database archived logs are created by the Oracle system. The Oracle database can run in one of the following logging modes:
- ARCHIVELOG turned on — logs are saved and can be used for recovery purposes.
- ARCHIVELOG turned off — no archived logs are saved. This mode is not recommended as it does not provide for proper disaster recovery.
With ARCHIVELOG turned on, the Oracle system stores database archived logs to a certain location on the machine that runs the database system, as specified by the database administrator. Veeam Agent for Microsoft Windows allows you to set up the following ways of log handling:
- Instruct the backup job to collect log files from the Oracle system and ship them to the backup location where they are stored next to regular backup files created by Veeam Agent for Microsoft Windows.
- Skip log processing — log files remain untouched and are preserved within the Veeam Agent backup.
If you enable application-aware processing for Oracle, during the job session Veeam Agent for Microsoft Windows collects information about the database and processes archived logs according to job settings. Application-specific settings are configured at the Guest Processing step of the New Backup Job wizard — you can specify how logs should be backed up and/or truncated for Oracle databases.
Requirements for Oracle Archived Log Backup
- Veeam Agent for Microsoft Windows supports archived logs backup and restore for Oracle database version 11.2 and later.
- Automatic Storage Management (ASM) is not supported.
- The database must run in the ARCHIVELOG mode.
- Database Log Backup Job
- How Microsoft SQL Server Log Backup Works
- How Oracle Archived Log Backup Works
- Retention for Database Log Backups