Adding SQL Server Instances |
See Also |
To back up or restore a database, you must first add the SQL Server instance to SQL Backup. SQL Backup displays the list of SQL Server instances that have been added in the Registered SQL Servers pane.
You can add the SQL Server instances by:
When you have added a SQL Server instance, you can:
The Add SQL Server dialog box is displayed.
If you experience problems selecting a SQL Server instance that is not running on the LAN, for example if you are accessing the SQL Server instance via an internet connection, you may need to create a SQL Server alias using TCP/IP; refer to your SQL Server documentation for details. You can then type the SQL Server alias name in the SQL Server box to connect to the remote SQL Server. (Note that this SQL Server alias is not the same as the SQL Backup alias, entered below.)
For Windows authentication, the credentials of the current user are used.
For SQL Server authentication, you can select the Remember Password check box. The password will be encrypted. If you do not select Remember Password, when you next start SQL Backup will be displayed next to the SQL Server instance name to indicate that SQL Backup has not attempted to connect to the SQL Server instance; double-click the icon or click to enter the authentication details.
For more information about locations, see Time Settings and Locations in The Time Line.
For more information about groups, see Managing SQL Server Groups.
The alias will be displayed throughout the SQL Backup graphical user interface.
For details, see Setting the Connection Properties.
SQL Backup adds the SQL Server instance. This may take a few minutes. The SQL Server instance is displayed in the Registered SQL Servers pane.
If there was a problem with the authentication, is displayed next to the SQL Server instance name. For example, this is displayed if you have entered the password incorrectly. Click the icon to correct the authentication details.
If there was a problem connecting to the SQL Server instance, is displayed next to the SQL Server instance name. Click the icon to see further details of the problem.
To change the connection properties:
The available client protocols are those configured in Microsoft SQL Server using the Client Network Configuration in Computer Management.
The default value is 4096 bytes.
The default setting is 15 seconds.
The default value is zero seconds (no time-out).
To select SQL Server registrations that exist already on SQL Backup version 4, SQL Server Management Studio, or SQL Server Enterprise Manager:
The Import SQL Server Registrations dialog box is displayed showing any existing SQL Server registrations in a tree structure.
For more information about locations, see Time settings and locations.
SQL Backup imports the SQL Server instances.
To change the SQL Server authentication or the connection properties:
To remove a SQL Server instance from the Registered SQL Servers pane, do one of the following:
To remove all SQL Server instances in a SQL Server group and delete the group, do one of the following:
© Red Gate Software Ltd 2007. All Rights Reserved.