We are trying to create a SQL Alias as given on this link SQL ALias
We have 2 SQL Servers, one is the main server and other is the Mirror. The DBA alter these servers at any time.
What we need to specify at the server name? (Main server or mirror) In future if the DBA Changes the mirror server to main, do we need to change in SQL Alias as well?