Creating a Microsoft SQL Server (VSS-aware) backup set
To create a Microsoft SQL Server (VSS-aware) backup set:
1. On the Sets menu, click New Backup Set. The New Backup Set Wizard appears.
2. On the Choose the kind of backup set page, select VSS-aware Backup Set, and then click Next.
3. On the Select the VSS-aware backup set type page, select Microsoft SQL Server.
4. Click Next.
5. On the Select the computer page, select the computer where the backup target is located. If the name resolution to IP address is not functional, create the backup set by typing the IP address in the Path field.
NOTE: If the Microsoft SQL Server is running on a remote machine or the DS-Client is running in a Docker container, you might need to add the Microsoft SQL Server IP address and host name to the hosts file on the DS-Client. The default path is: C:\Windows\System32\drivers\etc\hosts
By default, DS-Client uses the current user’s logon credentials to connect to the selected computer.
NOTE: To create a backup set of a Microsoft SQL Server Always On Availability Group, type the name or IP address of the Availability Group Listener.
6. To specify alternate logon credentials, select Ask for Network Credentials.
7. Click Next.
a) If you have selected Ask for Network Credentials, the Enter Network Credentials dialog box appears.
b) (If applicable) Type the credentials to the target computer, and then click OK.
8. On the Select the components to backup page, browse the VSS components list, select the required databases, and then click Add.
9. Click Next.
10. On the Specify backup item options page, retain the default settings unless there are specific generation or option requirements for each backup item, and then click Next.
11. On the Specify backup set options page, retain the default settings unless there are specific backup set requirements, and then click Next.
12. On the Specify backup set performance options page, retain the default settings unless there are specific backup set requirements, and then click Next.
13. On the Specify notification options page, retain the default settings unless there are specific backup set requirements, and then click Next.
NOTE: A VSS-aware backup set of a Microsoft SQL Server’s ‘master’ database does not support the ‘Full+Differential’ database backup policy.
14. On the Choose a retention rule for this backup set page, retain the default settings unless there are specific backup set requirements, and then click Next.
15. On the Choose a schedule for this backup set page, retain the default settings unless there are specific backup set requirements, and then click Next.
16. On the Choose the name for this backup set page, retain the default settings unless there are specific backup set requirements, and then click Finish.