I have a SQL server serverA that is being retired due to age and 2 databases that are being moved to a new server. What I want to do is take serverA completely off of the domain and bring the new server online, rename it to ServerA, then install SQL and name it's instance the same as the server that is being retired. We have hundreds of Crystal reports and do not want to have to modify them to access the data on the new server so we want to just bring it online as if it was the old server. I believe I have the steps covered but just want to double check my list here with other IT pro's...
Original ServerA: After backing up the databases remove from the Domain through the usual method and rename and or shut down.
DC 1: -AD Users and Computers, Computers Folder - delete Server A
BDC: -AD Users and Computers, Computers Folder - delete Server A
DNS: Remove all ServerA records on DC 1 and BDC in forward look up zones, reverse look up zones including any PTR records
DHCP: Delete any leases and or reservations related to ServerA etc.
Rename the new server to ServerA
Attach to domain
Install SQL server and name instance to same name as SQL instance on retired server
Restore databases
Anything I am missing to remove the old computer from the network so that the new one comes up seamlessly?
Any assistance is greatly appreciated.
Thanks
Original ServerA: After backing up the databases remove from the Domain through the usual method and rename and or shut down.
DC 1: -AD Users and Computers, Computers Folder - delete Server A
BDC: -AD Users and Computers, Computers Folder - delete Server A
DNS: Remove all ServerA records on DC 1 and BDC in forward look up zones, reverse look up zones including any PTR records
DHCP: Delete any leases and or reservations related to ServerA etc.
Rename the new server to ServerA
Attach to domain
Install SQL server and name instance to same name as SQL instance on retired server
Restore databases
Anything I am missing to remove the old computer from the network so that the new one comes up seamlessly?
Any assistance is greatly appreciated.
Thanks