MSSQL server selection: adding and configuring MSSQL servers for backup

 

Accessing MSSQL server selection
To access the MSSQL server selection shown above:

  1. Click Jobs in the navigation bar
  2. Right-click on the desired job and select Edit.
  3. Click SQL server on the left menu.
  4. Click MSSQL server selection to expand the section.
Adding MSSQL servers for backup

You can add as many SQL servers for backup as required, and each can be configured separately. SQL backups configured in an NTBackup Method job will only perform full backups of SQL databases. To perform transaction log backups of your SQL databases, you need to create a SQL Method backup job.
Selecting a backup method

  1. Click Add MSSQL server to backup data from a Microsoft® SQL server.
  2. BackupAssist will then attempt to detect MSSQL servers available on the network. A new window will appear listing all MSSQL servers that were detected.
  3. Either select a SQL server from the Server drop-down menu or input the name or IP address of the SQL server directly.
  4. Click Connect to establish a connection with the SQL server.
  5. You will then be asked to supply authentication credentials to connect to the SQL server:
    1. Check Use the BackupAssist user identity if the SQL server supports Windows authentication and the backup user identity has access to the SQL server.
    2. Uncheck Use the BackupAssist user identity if the SQL server supports either mixed authentication (Windows and SQL) or SQL authentication only. You can then input a valid user name and password.
  6. Now select which databases to backup from the SQL server:
    • Check Select all if you wish to backup all databases and any future databases that are created. You can exclude specific databases if required by unchecking them; all future databases created will still be backed up.
    • Uncheck Select all to select each database individually to backup. No databases created in the future will be backed up, only those selected.
  7. Finally, click Add to add the SQL server and databases to your backup selections.
Suspending, editing and removing MSSQL server backups

Once added, you can edit which databases are backed up from your MSSQL servers as well as temporarily suspending SQL server selections from being backed up, or remove them entirely.

  1. To suspend or prevent an added SQL server from being backed up, without removing it, uncheck the box next to the name of the SQL server. Check the box to re-enable the database selection for that SQL server. This is sometimes useful if you encounter problems with your databases backups and need to temporarily disable selections while resolving the issue.
  2. To edit database selections for an added SQL server:
    1. Check Select all if you wish to backup all databases and any future databases that are created. You can exclude specific databases if required by unchecking them; all future databases created will still be backed up.
    2. Uncheck Select all to select each database individually to backup. No databases created in the future will be backed up, only those selected.
  3. To remove an SQL server from the backup selections permanently, click the Remove icon to the right of the SQL server you wish to remove.