---
title: "Set-VBRMSSQLProcessingOptions"
description: "Modifies the Microsoft SQL Server database processing settings for application backup policies. Product Edition: Standard, Enterprise, Enterprise Plus, Veeam Universal License This cmdlet applies to application backup policies for Veeam Plug-In for M"
canonical: "https://helpcenter.veeam.com/docs/vbr/powershell/set-vbrmssqlprocessingoptions.html"
breadcrumb: "Veeam PowerShell Reference > Veeam PowerShell Reference > Veeam Plug-Ins for Enterprise Applications, MongoDB Backup and Epic EHR System Protection > Working with Managed Veeam Plug-Ins, MongoDB Backup and Epic EHR System Protection > Application Backup Policy Settings for Veeam Plug-In for Microsoft SQL Server > Set-VBRMSSQLProcessingOptions"
dateModified: "2026-08-19"
---

# Set-VBRMSSQLProcessingOptions

## Short Description
Modifies the Microsoft SQL Server database processing settings for application backup policies.

**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

<table style="width:100%;" class="Blue_Table">
      <tr style="vertical-align:top">
        <th style="width:20%;">
          <p>Parameter</p>
        </th>
        <th style="width:20%;">
          <p>Description</p>
        </th>
        <th style="width:20%;">
          <p>Type</p>
        </th>
        <th style="width:10%;">
          <p>Required</p>
        </th>
        <th style="width:10%;">
          <p>Position</p>
        </th>
        <th style="width:10%;">
          <p>Accept Pipeline Input</p>
        </th>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">EnableCopyOnlyBackup</span></p>
        </td>
        <td>
          <p>Enables copy-only mode for backups. Using this parameter can prevent backup chain disruptions.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">EnableLogBackup</span></p>
        </td>
        <td>
          <p>Enables Microsoft SQL Server log backups when creating SQL processing options objects for application backup policies.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">LogBackupPeriod</span></p>
        </td>
        <td>
          <p>Modifies the integer defining the frequency for logs backup in minutes.</p><p>Permitted values: <code>5</code> to <code>480</code>.</p>
        </td>
        <td style="width:10%;">
          <p><code>Int32</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Options</span></p>
        </td>
        <td>
          <p>Specifies the database processing options that you plan to modify.</p><p>Accepts the <code>VBRMSSQLProcessingOptions</code> object. To get this object, run the <a href="new-vbrmssqlprocessingoptions.md"><code>New-VBRMSSQLProcessingOptions</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><code>VBRMSSQLProcessingOptions</code></p>
        </td>
        <td style="width:10%;">
          <p>True</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>True (ByValue)</p>
        </td>
      </tr>
    </table>

`<CommonParameters>`

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see [ Microsoft Docs](https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_commonparameters?view=powershell-7).

## Examples

::: 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:

1. Run the [`New-VBRMSSQLProcessingOptions`](new-vbrmssqlprocessingoptions.md) cmdlet. Specify the following settings: 

   1. Provide the `EnableLogBackup` parameter. 
   2. Specify the `LogBackupPeriod` parameter with the number of minutes. 
   3. Provide the `EnableCopyOnlyBackup` parameter. 
   4. Save the result to the `$sqloptions` variable.

2. Run the `Set-VBRMSSQLProcessingOptions` cmdlet. Specify the `Options` parameter with the `$sqloptions` variable.

:::