We are running various System Center products, SCSM, SCVMM, SCCM, DPM, OPALIS. and a few other servers all using the same SQL server, which currently is a VM. We have configured and built a new Physical box that will replace this.
In the past we have moved SQL databases by doing a full backup and then restoring the backup on the new server, then renaming the servers, both network name and internal sql name. This has worked fine in the past. However I've never had to move 30
databases before, nor have I had to move reporting services.
Is there a better method. a recomended method?
View Complete Post