Switching SQL Server via DNS ?
We have found out that we need to decommission our sql server box. Unfortunately, there is the fear that we may not be able to repoint (change connection strings) on all of our existing applications as some of these may be hardcoded. Would like to stand up a box with the same name,or create an alias.
Would like to know if anyone has tried to use a dns entry repoint to a new SQL Server. Again, the idea here is we will hopefully not have to touch any code or connection strings. This would most likely be going from Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) to SQL Server 2012.
If anybody could provide a list of steps to do it would be greatly appreciated.
Thank you in advance,
Jason
Would like to know if anyone has tried to use a dns entry repoint to a new SQL Server. Again, the idea here is we will hopefully not have to touch any code or connection strings. This would most likely be going from Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) to SQL Server 2012.
If anybody could provide a list of steps to do it would be greatly appreciated.
Thank you in advance,
Jason
ASKER
Thank you for the checklist. This would most likely be a upgrade in SQL Server version to 2012 as well (in addition to it physically moving) so I'm not sure if we would copy over the system databases like master and msdb. Most likely not.
Truth is we haven't really decided on a name yet for the new server. My personal opinion would be to give it the same name as the box we are decommissioning (the old box). Then change dns entries. I am just trying to get a grip on what will be needed.
Jason
Truth is we haven't really decided on a name yet for the new server. My personal opinion would be to give it the same name as the box we are decommissioning (the old box). Then change dns entries. I am just trying to get a grip on what will be needed.
Jason
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you planning to build our server2 with a different name then backup and restore the databases to server2 (users and security principals as well) and then rename server2 to match server1 ?
IF so AD will take care of the DNS repoint once the server name is updated in the AD.
You can also probably indicate the downtime
Rename the old server, build the new server with the current name then proceed to complete.
SQL server Migration checklist:
http://yrushka.com/index.php/database-recovery/sql-server-migration-from-one-server-to-another-detailed-checklist/