Monday, June 27, 2011 2:03 PMWe have migrated several dtabases from 2000 to R2. Everything is fine. But the only problem we have taken the 2000 databases offline but now the DNS alias is unable to redirect the traffic to the new server as the old server is still not shutdown and DNS alias is hitting the old server. As a result the applications are failing. Can we rename the old server to get over this issue?
Monday, June 27, 2011 2:36 PM
Please check here
hope this helps you
Monday, June 27, 2011 3:03 PMCan I go and give an alias name to the server as a old server for time being?would that work?
Tuesday, June 28, 2011 5:54 PM
Yes you can rename the Old Server running SQL Server 2000 to SERVEROLD
Also run "ipconfig /flushdns" on webserver or client computer accessing SQL server , so that DNS cache will be cleared as well and resolute to new server properly
Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
If you found this post useful, Please "Mark as Answer" or "Vote as Helpful"
Wednesday, July 06, 2011 2:38 PMPlease Use "FQDN" with shutting down old server ....It will grab new server alias automatically.