Registered SQL Servers Pane

The Registered SQL Servers pane displays a list of the SQL Server instances you have registered with SQL Backup Manager, and their databases.

You use this list to select the SQL Server instance or database that you want to back up or restore, or for which you want to view details such as the activity history.

Navigating the Registered SQL Servers pane

The SQL Server instances are organized into groups. You choose the group to which you want an instance to belong when you register it. To change the group to which an instance belongs, in the Registered SQL Servers pane, drag the SQL Server instance to the group. For information about creating and managing groups, see Managing SQL Server Groups.

Display

The status of each SQL Server instance is displayed:

Connected.
SQL Backup Manager has not attempted to connect to the SQL Server because you are using SQL Server authentication and you chose not to save the password when you entered the authentication details. Double-click the icon or click , and then type the password. If you want to save the password in future, select the Remember Password check box.
SQL Backup Manager could not connect to the SQL Server because of an authentication error, such as an incorrect password. Click the icon to enter the correct details.
SQL Backup Manager could not connect to the SQL Server. Click the icon to see the associated error messages. Note that you can specify the time for which SQL Backup Manager will attempt to connect each SQL Server in the connection properties.
SQL Backup Manager is activated for a trial period on this SQL Server. On the Action menu, click Active License if you have purchased a license and you would like to activate it. For more information, see Activating SQL Backup Manager.
SQL Backup Manager is installed and activated on this SQL Server, but the version of server components is not up-to-date compared with your version of the graphical user interface. On the Action menu, click Install or Upgrade Server Component to upgrade the server components.
You have not installed the SQL Backup Manager server components on the SQL Server. Click the icon to install the server components. For more information, see Installing and Upgrading SQL Backup Manager.
The SQL Backup Manager trial period has expired. To use SQL Backup Manager with this SQL Server instance, you must activate SQL Backup Manager for the SQL Server. Click the icon if you have purchased a license and you would like to activate it. For more information, see Activating SQL Backup Manager.
SQL Backup Manager is connecting to the SQL Server instance, or refreshing the connection.

For each connected SQL Server instance, you can click to see the databases on the instance. The status of each database is displayed:

Operational. The database is fully usable. Transaction log backups and differential backups cannot be restored to this database.
The database is being restored, or it has been left in a non-operational state (using WITH NORECOVERY) so that differential backups and transaction log backups can be restored to it.
The database is read-only. If the database is read-only because it has been left in a standby state (using WITH STANDBY), transaction log backups and differential backups can be restored to this database.
The database is unavailable because it has been set to a SUSPECT or EMERGENCY state. Refer to your SQL Server documentation for more information.
The database is offline or in an unknown state.

Refreshing the data

To refresh the display for a SQL Server, click the SQL Server in the Registered SQL Servers pane, and press F5. is displayed next to the SQL Server instance while SQL Backup Manager refreshes the connection. Note that if the SQL Server is busy, there may be a short delay before the display refreshes.

Interaction

Whenever applicable, the SQL Backup Manager features and displays act on the item you select in the Registered SQL Servers pane. For example, if you have a database selected and you click Backup, the Backup wizard pre-selects the database for you (you can change the selection in the wizard).

Similarly, the Activity History, In Progress, or Jobs tab is updated with information related to the selected item. For example, if the Activity History tab is displayed and you click a SQL Server instance name, all activities that have occurred on that instance are shown in the tab; if you then click a database, only those activities that occurred on the selected database are shown in the tab.

To see the properties of a SQL Server or database, right-click on the item of interest and click Properties.