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"
Note: After the new application is fully configured, save the changes and go to the Backup SLAs configuration.
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