Set-VBRMSSQLProcessingOptions
Short Description
Modifies the Microsoft SQL Server database processing settings for application backup policies.
Applies to
Product Edition: Standard, Enterprise, Enterprise Plus, Veeam Universal License
Syntax
Set-VBRMSSQLProcessingOptions -Options <VBRMSSQLProcessingOptions> [-EnableLogBackup] [-LogBackupPeriod <Int32>] [-EnableCopyOnlyBackup] [<CommonParameters>] |
Detailed Description
This cmdlet applies to application backup policies for Veeam Plug-In for Microsoft SQL Server.
Use this cmdlet to modify Microsoft SQL Server database processing settings. You can modify the following options:
- Enable or disable transaction log backup.
- Modify the period for transaction log backups.
- Enable or disable the copy-only backup without interrupting the backup chain.
Parameters
Parameter | Description | Type | Required | Position | Accept Pipeline Input |
|---|---|---|---|---|---|
Options | Specifies the database processing options that you plan to modify. | Accepts the VBRMSSQLProcessingOptions object. To get this object, run the New-VBRMSSQLProcessingOptions cmdlet. | True | Named | True (ByValue) |
EnableLogBackup | Enables Microsoft SQL Server log backups when creating SQL processing options objects for application backup policies. | SwitchParameter | False | Named | False |
LogBackupPeriod | Modifies the integer defining the frequency for logs backup in minutes. Permitted values: 5 to 480. | Int32 | False | Named | False |
EnableCopyOnlyBackup | Enables copy-only mode for backups. Using this parameter can prevent backup chain disruptions. | SwitchParameter | False | Named | False |
<CommonParameters>
This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see Microsoft Docs.
Example
Modify SQL Processing Options for Veeam Plug-In for Microsoft SQL Server Application Backup Policies
This example shows how to modify existing Microsoft SQL Server processing options for application backup policies for Veeam Plug-In for Microsoft SQL Server.
$sqloptions = New‑VBRMSSQLProcessingOptions -EnableLogBackup -LogBackupPeriod 30 -EnableCopyOnlyBackup Set‑VBRMSSQLProcessingOptions -Options $sqloptions |
Perform the following steps:
- Run the New‑VBRMSSQLProcessingOptions cmdlet. Specify the following settings:
- Provide the EnableLogBackup parameter.
- Specify the LogBackupPeriod parameter with the number of minutes.
- Provide the EnableCopyOnlyBackup parameter.
- Save the result to the $sqloptions variable.
- Run the Set‑VBRMSSQLProcessingOptions cmdlet. Specify the Options parameter with the $sqloptions variable.