Step 2: Instance Selection

Select MS SQL Server

Select the Server which you want to configure backup for.

Select MS SQL Server Instance

Select from the list of MS SQL Server instance by clicking on the drop down menu.

To ensure that the MS SQL Server instances are listed, it’s essential to confirm that the BDS (BDRSuite Delegation Services) are running with administrative privileges on the target host.

To manually add the instance you click on Add MSSQL Instance Server option. You can enter the instance name and save.

Proceed with Previously chosen Authentication

If you have already configured the MS SQL Server backup in the BDRSuite Backup Server then you can proceed with ‘Yes’ (By default selected) to use the same authentication type chosen on the first/previous time a MSSQL backup was configured, for the next subsequent backup configurations.

If you are configuring the MSSQL Server backup for the first time in the BDRSuite Backup Server then you can proceed by selecting the Authentication type.

• Use Windows Authentication (Recommended) – You can choose this option to authenticate using the Windows Host Credentials. (Ensure that the provided credentials have administrative privileges. If the installed BBA/BDS (BDRSuite Delegation Service) is currently running on the Local System Account, modify it to operate with administrative privileges in the Services settings of your Windows machine).
• Use MSSQL Server Authentication – You can choose this type to authenticate using the MSSQL Server credentials.

MSSQL Database Credentials – Select the existing credentials or click on Add credentials to add a new one.

Backup Data Dump Location

Enter the path to temporarily dump the backup data on the database server before initiating the backup process. By default the dump location selected at the time of adding data source will be used. If you want to customize the dump location for each backup job then you can do that by clicking on the ‘select location’ icon.