This is an XOsoft (CA ARCserve RHA) specific thread. With that product there are 4 methods of 'Network Traffic Redirection":

1) Redirect DNS: The DNS A-record of the Master is updated with the IP Address of the Replica.

2) Switch Host Name: The Replica is renamed to the hostname of the Master. If teh master is online, then the master is first renamed and the master's host name is appended with either a "-xo" or a "-RHA" (depending on the version). This avoids a duplicate host name contention issue during switchover.

3) Move IP: The IP address of the Master is removed and added to the Replica server. This requires that both the master and replica be on the same subnet.

4) User Defined Scripts: This is a custom redirection method performed by executing scripts written by the customer to customize the switchover and redirection process.

The method or combination of methods used is dependant on the environment and how the client or server applications are configured to connect to the Master server.

If the client and/or server apps are configured to resolve the SQL server name using DNS, then redirect DNS can be used. If you're using NETBIOS resolution, then switch host name can be used. You shouldn't need to change the server name in the system DB's. If this is necessary, then using switch host name would resolve the issue. Otherwise using the stored procedure listed above in a user defined script will be an alternative method to address that issue.

If you could clearly describe the problem or concern you are having specifically with XOsoft (CA ARCserve RHA) I'd be happy to assist further.