You are here: Workload protection > Application protection > SQL Server protection > Selecting source and target SQL servers

Selecting source and target servers

If you have not done so already, launch the Protecting a SQL Server workflow.

If this is your first time to select a SQL server to protect, you may need to click the Advanced Find button to add servers to the Source Server and Target Server fields. For more information, see Adding or managing servers.

If you select a source/target pair for which you have previously enabled and disabled protection, you may use the existing configuration settings (provided that the source/target connection is not currently active, in which case the existing settings will always be used). When you select Configure or Validate, a prompt will appear asking if you want to re-use the previous configuration information. Click Yes to re-use the previous information, or click No to revert to the Application Manager default settings.

Note:

If the IP address(es) for the source or target server have changed since you originally configured protection (for example, if you configure the source or target in a staging area and then send it to a production location), you must re-configure the protection settings. When you are prompted to re-use the previous protection configuration, click No, then click the Configure Protection button.

  1. In the Source Server field, select the SQL server that you want to protect. If this is your first time to log in to the selected server, you will be prompted to enter server login information. For more information about logging in to servers, see Entering server login information.

Note:

You cannot protect a server if it is already functioning as a target server.

If you attempt to select a source that is currently unavailable, a prompt will appear stating that the source is not available and that if the source is failed over, you should first select the target.

If you select the target, then select the source (as recommended in the prompt), the same prompt appears (though you would expect to get a prompt to failover). The ability to failover using the Application Manager will not be available until a failover condition has been met in accordance with the failover monitor settings set on the Monitoring tab.

  1. In the Target Server field, select the backup SQL server that will protect the source server in the event of a failure.

Notice that after the source and target servers are selected, the Protection Status on the Monitor tab changes to Unprotected.

Note:

If you first select a target that is monitoring a connection that has met a failover condition and requires manual intervention, then select the protected source server, a prompt will appear asking if you want to initiate failover.

Adding or managing servers
Entering server login information
Using clustered SQL servers

Next step: Select SQL instances

Related Topics