New-VBRSQLProcessingOptions
Short Description
Defines settings for processing Microsoft SQL database transaction logs.
Applies to
Product Edition: Community, Standard, Enterprise, Enterprise Plus
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 about common parameters, see http://go.microsoft.com/fwlink/p/?LinkID=113216.
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.