New-VBRSQLProcessingOptions
Short Description
Defines settings for processing Microsoft SQL database transaction logs.
Applies to
Product Edition: Community, Standard, Enterprise, Enterprise Plus, Veeam Universal License
Syntax
New-VBRSQLProcessingOptions -TransactionAction <VBRSQLTransactionLogAction> {Truncate | NotTruncate | BackupPeriodically} [-Credentials <CCredentials>] [-LogBackupPeriod <int>] [-LogRetainAction <VBRLogRetainAction>{WaitForBackupDeletion | KeepOnlyLastDays}] [-LogRetainPeriod <int>] [<CommonParameters>] |
Detailed Description
This cmdlet creates the VBRSQLProcessingOptions object that contains Microsoft SQL database transaction logs settings for Veeam Agent backup jobs. You can set up the following options:
- The way Veeam Backup & Replication will process transaction logs
- Specify schedule settings for processing transaction logs
For more information about custom scripts, see the Transaction Log Settings: Microsoft SQL Server section of the Veeam Agent Management Guide.
|
This cmdlet works for the Veeam Agent jobs that back up Windows computers only. |
Parameters
Parameter | Description | Required | Position | Accept | Accept |
---|---|---|---|---|---|
TransactionAction | Specifies transaction logs processing actions.
| True | Named | False |
|
Credentials | Specifies the credentials that Veeam Agent for Microsoft Windows will use to connect to the Microsoft SQL Server. | False | Named | False |
|
LogBackupPeriod | For the BackupPeriodically action. Specifies the number of minutes for transaction logs backups. Default: 15. | False | Named | False |
|
LogRetainAction | For the BackupPeriodically action. Specifies retention policy for transaction logs stored in the backup repository.
| False | Named | False |
|
LogRetainPeriod | For the BackupPeriodically action. Specifies the number of days to keep the transaction logs. Default: 15. | False | Named | False |
|
<CommonParameters>
This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the About CommonParameters section of Microsoft Docs.
Return Type
Example
This command creates SQL processing settings for a Veeam Agent job that backs up Windows computers. The job will run with the following options:
- Veeam Backup & Replication will backup SQL transaction logs every 25 minutes.
- Veeam Backup & Replication will keep the transaction logs for last 7 days.