We are about to go through the process of refreshing our SQL servers and someone came up with a bright Idea.
For all out client applications (Web sites, thick client apps) instead of using the names of the new servers we setup DNS names for all the applications we set up DNS aliases
So we have 2 servers that are called SKY and STARS
On our internal DNS servers we create a alias WebsitePrimary and point it to Sky and WebsiteSecondary and point it to Stars
sqlconn = "Provider=SQLNCLI10;Data Source=SUN;Failover Partner=WebsiteSecondary;Initial Catalog=WebsitePrimary;uid=readweb;pwd=changeme;"
So when I build the new servers - I move the data - point the DNS to the right servers
refresh dns on the web server and start tings up again (probably stopping the database on the old server to be safe)
Is there anything wrong with doing this ?