---
title: "Set-VBRSQLProcessingOptions"
description: "This cmdlet modifies Microsoft SQL database transaction logs settings for Veeam Agent backup jobs. To modify settings, specify new values for the necessary parameters. The cmdlet will overwrite the previous parameter values with new values."
canonical: "https://helpcenter.veeam.com/docs/vbr/powershell/set-vbrsqlprocessingoptions.html"
breadcrumb: "Veeam PowerShell Reference > Veeam PowerShell Reference > Veeam Agent Management > Working with Veeam Agent Backup Jobs and Policies > Veeam Agent Job Guest Processing Options > Set-VBRSQLProcessingOptions"
dateModified: "2026-08-19"
---

# Set-VBRSQLProcessingOptions

## Short Description
Modifies settings for processing Microsoft SQL database transaction logs.

**Product Edition**: Community, Standard, Enterprise, Enterprise Plus, Veeam Universal License

## Syntax
```
Set-VBRSQLProcessingOptions -Options <VBRSQLProcessingOptions> [-Credentials <CCredentials>]
 [-TransactionAction <VBRSQLTransactionLogAction>] [-LogBackupPeriod <Int32>]
 [-LogRetainAction <VBRLogRetainAction>] [-LogRetainPeriod <Int32>] [-UseSqlAuthentication] [<CommonParameters>]
```

## Detailed Description
This cmdlet modifies Microsoft SQL database transaction logs settings for Veeam Agent backup jobs.

::: note

To modify settings, specify new values for the necessary parameters. The cmdlet will overwrite the previous parameter values with new values. The parameters that you omit will remain unchanged.

:::

## 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">Credentials</span></p>
        </td>
        <td>
          <p>Specifies the credentials that Veeam Agent for Microsoft Windows will use to connect to the Microsoft SQL Server.</p>
        </td>
        <td style="width:10%;">
          <p><code>CCredentials</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>For the <code>BackupPeriodically</code> action.</p><p>Specifies the number of minutes for transaction logs backups.</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">LogRetainAction</span></p>
        </td>
        <td>
          <p>For the <code>BackupPeriodically</code> action.</p><p>Specifies retention policy for transaction logs stored in the backup location.</p><ul><li><code>WaitForBackupDeletion</code>: use this option to keep transaction logs backups the same period as image-level backups.</li><li><code>KeepOnlyLastDays</code>: use this option to keep transaction log backups for a specific number of days.</li></ul>
        </td>
        <td style="width:10%;">
          <p><code>VBRLogRetainAction</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">LogRetainPeriod</span></p>
        </td>
        <td>
          <p>For the <code>BackupPeriodically</code> action.</p><p>Specifies the number of days to keep the transaction logs.</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 SQL transaction logs processing settings that you want to modify.</p><p>Accepts the <code>VBRSQLProcessingOptions</code> object. To get this object, run the <a href="new-vbrsqlprocessingoptions.md"><code>New-VBRSQLProcessingOptions</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><code>VBRSQLProcessingOptions</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>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">TransactionAction</span></p>
        </td>
        <td>
          <p>Specifies transaction logs processing.</p><ul><li><code>Truncate</code>: use this option to truncate transaction logs after the successful backup job.</li><li><code>NotTruncate</code>: use this option to preserve transaction logs after the backup job completes.</li><li><code>BackupPeriodically</code>: use this option to back up transaction logs periodically.</li></ul>
        </td>
        <td style="width:10%;">
          <p><code>VBRSQLTransactionLogAction</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">UseSqlAuthentication</span></p>
        </td>
        <td>
          <p>Defines that Veeam Agent for Microsoft Windows will use SQL Server authentication to connect to the Microsoft SQL Server. If you specify this parameter, use the Credentials parameter to provide the account credentials.</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>
    </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).

## Output Object
This cmdlet returns the `VBRSQLProcessingOptions` object that contains settings for processing Microsoft SQL database transaction logs.

## Examples

::: example
### Modifying SQL Processing Settings for Veeam Agent Backup Job (Windows)

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.

```
$sql = New-VBRSQLProcessingOptions -TransactionAction BackupPeriodically -LogBackupPeriod 25 -LogRetainAction KeepOnlyLastDays -LogRetainPeriod 7
Set-VBRSQLProcessingOptions -Options $sql -TransactionAction BackupPeriodically -LogBackupPeriod 30 -LogRetainAction WaitForBackupDeletion
```

Perform the following steps:

1. Run the [`New-VBRSQLProcessingOptions`](new-vbrsqlprocessingoptions.md) cmdlet. Specify the `TransactionAction`, `LogBackupPeriod`, `LogRetainAction` and `LogRetainPeriod` parameter values. Save the result to the `$sql` variable.
2. Run the `Set-VBRSQLProcessingOptions` cmdlet. Specify the following settings:

   - Set the `$sql` variable as the `Options` parameter value.
   - Set the `BackupPeriodically` option for the `TransactionAction` parameter.
   - Specify the `LogBackupPeriod` parameter value.
   - Set the `WaitForBackupDeletion` option for the `LogRetainAction` parameter.

:::

## Related Commands

[`New-VBRSQLProcessingOptions`](new-vbrsqlprocessingoptions.md)