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)
No comments:
Post a Comment