Set-VBRSQLProcessingOptions
Short Description
Modifies settings for processing Microsoft SQL database transaction logs.
Applies to
Product Edition: Community, Standard, Enterprise, Enterprise Plus
Syntax
Set-VBRSQLProcessingOptions -Options <VBRSQLProcessingOptions> [-Credentials <CCredentials>] [-TransactionAction <VBRSQLTransactionLogAction> {Truncate | NotTruncate | BackupPeriodically}] [-LogBackupPeriod <int>][-LogRetainAction <VBRLogRetainAction> {WaitForBackupDeletion | KeepOnlyLastDays}] |
Detailed Description
This cmdlet modifies Microsoft SQL database transaction logs settings for Veeam Agent backup jobs. To modify settings, enter the necessary parameters with new values. The parameters that you omit will remain unchanged.
Parameters
Parameter | Description | Required | Position | Accept | Accept |
Options | Specifies SQL transaction logs processing settings that you want to modify. Accepts the VBRSQLProcessingOptions type. | True | Named | True (ByValue) |
|
Credentials | Specifies the credentials that Veeam Agent for Microsoft Windows will use to connect to the Microsoft SQL Server. | False | Named | False |
|
TransactionAction | Specifies transaction logs processing.
| False | Named | False |
|
LogBackupPeriod | For the BackupPeriodically action. Specifies the number of minutes for transaction logs backups. | False | Named | False |
|
LogRetainAction | For the BackupPeriodically action. Specifies retention policy for transaction logs stored in the backup location.
| False | Named | False |
|
LogRetainPeriod | For the BackupPeriodically action. Specifies the number of days to keep the transaction logs. | 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 example shows how to modify the existing 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 back up the transaction logs every 30 minutes.
- Veeam Backup & Replication will keep the transaction logs backups until the image-level backup is deleted.
To modify the settings, perform the following steps:
- Run New-VBRSQLProcessingOptions to specify SQL processing settings. Save the result to the $sql variable.
- Run Set-VBRSQLProcessingOptions with the $sql variable. Specify the WaitForBackupDeletion value for the LogRetainAction parameter to keep the transaction logs until the image-level backup is deleted.
$sql = New-VBRSQLProcessingOptions -TransactionAction BackupPeriodically -LogBackupPeriod 25 -LogRetainAction KeepOnlyLastDays -LogRetainPeriod 7 Set-VBRSQLProcessingOptions -Options $sql -TransactionAction BackupPeriodically -LogBackupPeriod 30 -LogRetainAction WaitForBackupDeletion |
Related Commands