---
title: "New-VBRMSSQLOptions"
description: "Creates a new Microsoft SQL Server backup options object that defines how Microsoft SQL Server transaction logs and databases are handled during backup jobs."
canonical: "https://helpcenter.veeam.com/docs/vbr/powershell/new-vbrmssqloptions.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 > New-VBRMSSQLOptions"
dateModified: "2026-08-19"
---

# New-VBRMSSQLOptions

## Short Description
Creates a new Microsoft SQL Server backup options object that defines how Microsoft SQL Server transaction logs and databases are handled during backup jobs.

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

## Syntax
```
New-VBRMSSQLOptions [-ParallelChannelsCount <Int32>] [-LogBackupChannelsCount <Int32>] [-EnableCopyOnlyBackup]
 [-EnableDifferentialBackups] [<CommonParameters>]
```

## Detailed Description
This cmdlet applies to application backup policies for Veeam Plug-In for Microsoft SQL Server.

Use this cmdlet to configure Microsoft SQL Server specific parameters and apply them to a backup job or database object.

## 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><p><strong>Note</strong>: You cannot use this parameter together with the <code>EnableDifferentialBackups</code> parameter.</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">EnableDifferentialBackups</span></p>
        </td>
        <td>
          <p>Enables the creation of differential backups, in addition to full and transaction log backups.</p><p><strong>Note</strong>: You cannot use this parameter together with the <code>EnableCopyOnlyBackup</code> parameter.</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">LogBackupChannelsCount</span></p>
        </td>
        <td>
          <p>Defines the number of parallel channels used for transaction log backups.</p><p>Permitted values: <code>1</code> to <code>64</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">ParallelChannelsCount</span></p>
        </td>
        <td>
          <p>Specifies the number of parallel data channels that Veeam Backup & Replication uses to back up a Microsoft SQL Server database. Increasing the number of channels may increase the load on the Microsoft SQL Server and backup repository.</p><p>Permitted values: <code>1</code> to <code>64</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>
    </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
The cmdlet returns the `MSSQLOptions` object that defines Microsoft SQL Server backup settings.

## Examples

::: example
### Create SQL Backup Settings for Application Backup Policies for Veeam Plug-In for Microsoft SQL Server

This example shows how to create Microsoft SQL Server backup settings for application backup policies for Veeam Plug-In for Microsoft SQL Server. The policy will send application backups to the target storage using 4 parallel data channels, send transaction log backups using 2 parallel channels and enable copy-only backup mode.

```
New-VBRMSSQLOptions -ParallelChannelsCount 4 -LogBackupChannelsCount 2 -EnableCopyOnlyBackup
```

:::