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.