Create new SQL server to replace old - Keep Machine Name
Posted on 2012-04-11
I have a virtualized SQL server (we'll call SQL01). It is on the domain. I would like to move it to a physical box, but I need the physical box to keep the same name. The databases are huge. I'm looking for the best way to do this.
My concern is not knowing how SQL handles changes to the machine name. Not sure which is better:
1) Rename the old server to "SQL01-old", then name the new server "SQL01". Start the MSSQL install.
2) Install SQL on the new server, copy the database files over, then rename the servers
3) Something I haven't considered.
What do you think?