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)
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
I tried your "hack" and it worked fine - thanks for the idea.
Nice trick - Worked for me as well
Thanks Steve, worked for me.
For Standalone VMM (SC 2012) Server: http://blog.it-kb.ru/2012/08/08/system-center-vmm-2012-move-db-database-to-another-server-without-reinstall/
For Clustered HA VMM (SC 2012 R2): http://blog.it-kb.ru/2014/03/19/system-center-2012-r2-virtual-machine-manager-move-ha-highly-available-vmm-database-from-one-clustered-sql-server-to-another-without-reinstalling/
Wow what a great blog, i really enjoyed reading this, good luck in your work. Azure Administration for AWS SysOps AZ-010
Post a Comment