Add a new server using the ADVSoft SQL Backup management program:

Next, select the Microsoft SQL Server page and specify the required connection settings:

ADVSoft SQL Backup supports the following options for backing up databases:

Backup copies of MS SQL Server databases through the shared folder

In this mode, Microsoft SQL Server and the ADVSoftSQLBackup service should have access to the shared folder. The database server must have write access, and the ADVSoftSQLBackup service must have read and delete access. You do not need to install any additional software other than providing access to the shared folder.

You must specify the way in which the shared folder can be accessed by Microsoft SQL Server and the ADVSoftSQLBackup service in the server connection settings. For example, if a shared folder can be accessed by Microsoft SQL Server as a local folder (C:\Share\), but the ADVSoftSQLBackup service sees this path as \\SQLServerPC\Shares, then you will have to specify the appropriate path in the software settings:

Here is another example: let's assume that a shared folder is located at \\fileserver\share and this specific URI is available to both systems. In this case you will need to specify \\fileserver\share as the local folder for Microsoft SQL Server as well as for the ADVSoftSQLBackup service.

Microsoft SQL Server cannot be granted access rights to a shared network folder. You can check whether Microsoft SQL Server can access a given path using Management Studio by executing the following query: EXEC master.sys.xp_dirtree '\\SomeServer\Share\', 1, 1 , where \\SomeServer\Share\ is the UNC path that is being verified. If you are able to access the path, then you will see a list of files and folders in this directory. Otherwise, you will see an empty set.

In order to create backups in this mode, ADVSoft SQL Backup will need sysadmin access rights (role) on Microsoft SQL Server. You can use one of the following options to achieve this:

  1. Run the service when logged into an appropriate account that has sysadmin role privileges on Microsoft SQL Server
  2. Enter the username/password for the account in the ADVSoft SQL Backup settings
  3. Add the sysadmin role to the SYSTEM account in Microsoft SQL Server settings

Launching the "agent" from a special account

To launch the service using a special account, open the Services applet, find the ADVSoftSQLBackup service, and specify the desired account:

Adding the sysadmin role to the SYSTEM account in the MS SQL Server settings

To add the sysadmin role to the SYSTEM account in the Microsoft SQL Server settings, you can use Microsoft SQL Server Management Studio Express (which is available as a free download from Microsoft's website: https://www.microsoft.com/ru-ru/download/details.aspx?id=42299). Open the desired database and select the Security\Logins folder. Then you can enter the desired settings for the SYSTEM user:

Then you need to assign a sysadmin role for this user:

Creating MS SQL Server database copies using the ADVSoft SQL Backup Agent

The ADVSoft SQL Backup Agent must be installed on a PC with Microsoft SQL Server, and it allows you to create backups on the local network. In this case, there is no need for a shared folder between the PC with the database server and the PC where the ADVSoftSQLBackup service is running. After you install the "agent" on the Microsoft SQL Server PC, the ADVSoftSQLBackup service can obtain copies of the database over the network using information compression and encryption, which increases the speed of the transfer and reduces the load on your equipment and network hardware.

To select this mode in ADVSoft SQL Backup, use the option "Copy over the network" in the new server connection window:

Installing and configuring ADVSoft SQL Agent on the MS SQL Server PC

After you install the agent module on the Microsoft SQL Server PC, you will need to enter the monitored instances and access settings in the SQLAgent Manager:

In order for the "agent" service to function, it needs to be assigned sysadmin rights (role) on all processed instances of the Microsoft SQL Server as well as local administrator rights.

The following are ways of granting the "agent" service access to Microsoft SQL Server backup functions:

  1. The "Agent" service is run using a SYSTEM account. In this case, you must activate the sysadmin role for the SYSTEM account on all processed instances of the SQL Server.
  2. Run the "agent" using a SYSTEM account, but specify the username/password for the account in the Agent Manager settings that has been granted local administrator rights as well as the sysadmin role on the SQL Server.
  3. Run the "agent" using a separate account that has been granted local administrator rights as well as the sysadmin role on the Microsoft SQL Server.

Change the account that is used to run the "agent" service

To change the account that is used to run the "agent" service, open the Services applet and enter the desired settings for the ADVSoftSQLBackupAgent service:

Adding the sysadmin role to the SYSTEM account in the MS SQL Server settings

To add the sysadmin role to the SYSTEM account, connect to the desired Microsoft SQL Server instance using SQL Server Management Studio, then open Security – Logins and open the SYSTEM user's properties:

Activate the sysadmin role on the Server Roles page:

Using a separate account to run the "agent"

If you want to use a special separate account to run the "agent", you must create this account with local administrator privileges for the Windows control panel and assign the sysadmin role for Microsoft SQL Server to this account. Connect to the desired Microsoft SQL Server instance in SQL Server Management Studio and right click on the Login folder. Then select New Login:

After you add a "special" user to Microsoft SQL Server, you must add the sysadmin role for this user (see Assigning a sysadmin role for a SYSTEM user).