This isn't a common thing to need to do, but I found myself in the position today where I wanted to move the database that was on a local SQL install on a SCVMM 2012 server up onto a new SQL Cluster I had just finished building.
So these are the steps I took to move the database:
- Take a snapshot of the server (assuming it's a VM)
- Take a backup of the existing VMM DB
- Uninstall VMM and choose the Retain Database option
- Detach the VMM DB from the local SQL instance
- Copy the VMM DB files across to the new SQL Server
- On the remote SQL server, attach the VMM db
- Re-install SCVMM 2012 and when prompted, point it at the new SQL server, selecting to use an existing database (the one you imported)
4 comments:
Great post. But is there a way to do this without having to reinstall VMM? It would be great just to be able to make a configuration change in VMM to point to the other SQL server.
I've not tested it, and it's sure to be unsupported, but there is only 1 registry key that contains SQL information, so this might be as simple as altering those details.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft System Center Virtual Machine Manager Server\Settings\Sql
Steve,
I tried your "hack" and it worked fine - thanks for the idea.
Nice trick - Worked for me as well
Post a Comment