Figure 1. Create SQL Server Aliases.
You can set up a SQL Server alias in the SQL Server Client Network Utility. Any connections to MyServer end up connecting to MyBackupServer instead, without you modifying any connection strings. You set aliases on computers where your ADO or ADO.NET executes.