SQL Safe provides the ability to add, remove, and group SQL Server instances from within the tree pane.
How do you register an instance?
To register a SQL Server instance with SQL Safe:
- In the navigation pane, click Servers.
- Right-click on the Server Group to which you want to add the SQL Server instance.
- Select Register SQL Server from the context menu.
- In the Available Servers list of the Register SQL Servers dialog, select the instance you want to add to the Server Group.
- Click Add > and SQL Safe moves the selected server to the Added Servers list.
- Select the required authentication method used to log in to the SQL Server instance, and then click OK.
or
- Go to the Common Tasks section of the SQL Safe Today view, click Register SQL Server.
- Select the SQL Server Instance from the
add more option available on the Server name. - Assign a Friendly name for your SQL Server.
- Select the Server Group from the drop-down option.
- Determine the SQL Server Authentication method (Windows or SQL Server).
- Use the respective user name and password.
You can also register an instance "on the fly" when you back up the hosted databases through the Management Console.
How do you group SQL Server instances?
To group SQL Server instances, right-click the SQL Server instances folders on the pane tree of the Servers View and select Add Group, then you can Register SQL Servers to add them to the respective group.
Organizing your SQL Server instances into related groups can help you verify the backup status of specific types of SQL Server instances. For example, you can categorize servers based on location, purpose, importance, platform, or any other logical category.
How do you remove an instance?
To remove SQL Server instances, right-click the respective instance and select Remove SQL Server.
In the Servers tree, the SQL Server Instances node lists all the SQL Server instances you have registered with SQL Safe. However, this list may not reflect all registered SQL Server instances across your environment. For example, when your backup or log shipping policy contains instances registered by other database administrators, SQL Safe lists these instances in the Discovered Instances node. Although you can delete this node, SQL Safe recreates the node after a policy status is refreshed.