Show/Hide Toolbars

To start the wizard for inventorying your SQL servers, click the SQL Server button on the Inventory ribbon. The SQL Server step will be displayed after you have selected a company and a domain and entered your credentials (see: Basic Steps).

Docusnap-Inventory-SQL-Server

There are two ways to identify SQL servers:

Searching for SQL Servers Automatically
When you click the Start Search button, Docusnap will attempt to identify the SQL servers in your network. If SQL servers have been found, they will be listed in the SQL Servers Found table.

Entering an SQL Server Manually
In addition to an automatic search for SQL servers, you can specify a single SQL server in Docusnap manually. Click the New button and specify the system to be scanned subsequently.

In addition to the SQL server name, and the name of the instance if required, a dedicated port can also be specified for the inventory process. The port is separated by a comma ",".

The following icons indicate the access rights to an SQL server:

  • Docusnap-Inventory-SQL-Server-can-inventoriedThe SQL server can be scanned.
  • Docusnap-Inventory-SQL-Server-Can-limited-inventoriedThe server can only be scanned to a limited extent. In order to completely scan the server, you need to enter valid SQL authentication data manually.
  • Docusnap-Inventory-SQL-Server-cannot-inventoriedThe server cannot be scanned because you do not have the required permissions. In order to scan this server, you need to enter valid SQL authentication data manually.

When the connection to a SQL server is successful, it can be defined individually which databases are to be inventoried. Click the Docusnap-Inventory-SQL-Server-Expand btuoon to list all databases of the SQL server. To exclude databases from the inventory, check the checkbox to this database.

Using the Advanced Options button the following options for the inventory can be established. Using the Scan Tables and Scan Columns, you can specify the scope of the inventory scan. To determine the procedures to be scanned, you can select Scan Custom Procedures and Scan System Procedures. Using the Scan Procedure Source Code option, you can specify whether the procedure source code will be scanned as well.

During the scan of the SQL servers, the backup history is retrieved. If you tick the Limit Backup History checkbox, only the most recent entries will be retrieved. You can specify the number of entries to be saved in the Entries field.