# MSSQL

To create a new application for MSSQL instances backup, go to the tab: **Applications -> Instances**

Then select the **Create** button. The Creating an Application Definition section will be displayed, which needs to be completed.

This is a description of how your script is going to be invoked - you need to specify:

* **Name** - unique name of the application in the Storware Backup & Recovery system
* **Choose Node Config** - select which node should perform the task
* **Backup policy** - specify which backup policy should be used for this application
* **Command execution configuration** - select a prepared template for MSSQL backup

On the **Remote PowerShell access** subtab, complete the following fields:

* **Host** - set the address of the host where the MSSQL instance exists
* **Port** - set the host port

Next, select OS Credentials or create a new one and provide the following information:

* **Name** - unique name of the OS Credentials
* **User** - indicate a user for connecting to the PS
* **Password** - enter the connection password
* **SSH key path** - alternatively you can specify the ssh key path for authorization

After **saving** the changes to the application, you need to configure the **environment variables** in the **settings section** of your application as needed.

When using the built-in script for database backup, define:

* **VP\_MSSQL\_DBPASSWORD** - password to database user
* **VP\_MSSQL\_USER** - login username to MSSQL db
* **VP\_MSSQL\_DBNAME** - cmma separated list of database names to backup
* **VP\_MSSQL\_STOREPATH** - path on MSSQL server, where Storware Backup & Recovery can place the temporary backup file (no other files should be stored in the given path since everyting is removed after the backup is finished)
* **VP\_MSSQL\_COMPRESSION** - if backup should be compressed on MSSQL server, then please type "Yes"

{% hint style="info" %}
**Note:** After the new application is fully configured, **save** the changes and go to the [Backup SLAs](/backup-and-recovery-7.2/administration/applications/backup-slas.md) configuration.
{% endhint %}

**Note:** It is required to open port 5986 and 15702 in the firewall on the MSSQL host side. Start and enable use of WinRM, enable Basic authorization and add Storware Backup & Recovery Node to the list of trusted hosts.

For Storware Backup & Recovery Node it is required in the firewall to open port 15702.

You can always use prepared scripts that perform the above-mentioned actions:

* scripts/winrm\_firewall\_node.sh - execute the file on Storware Backup & Recovery Node
* scripts/winrm\_firewall\_windows.ps1 - copy from node to target host from MSSQL instance and execute
* scripts/winrm.ps1 - copy from node to target host from MSSQL instance and execute


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.storware.eu/backup-and-recovery-7.2/protecting-applications/applications/mssql.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.