We are swapping hardware on a server 2008 R2 server with SQL 2005 64bit SP3.
The current production server is working "server1", we added a new server "server2" to the LAN but have not joined it to the domain yet.
We have installed SQL 2005 64bit SP3 on Server2 and will set up the SQL instance and move the database from Server1 to server2. Once done we will shut down Server1 and change the IP address of Server2 to Server1's IP address and then rename Server 2 to Server1 and join the domain.
I think this will work but not 100%,
When i join the re-IP'ed, re-named and rebooted Serve1 to the existing domain will there be a problem with the DC? Do i have to drop the server name from the DC before joining the new Server1 server?
How will that impact the SQL instance if at all?
If i have to drop the server1 from the DC first how does that impact mapped drives to the Server1 from the existing workstations?
Note: the DC is a SBS2008 server.