Operations Manager 2007 R2 (SCOM) Version Numbers

Just a quick post to help me remember what release numbers relate to which cumulative update version:

Version (numeric)	Version (name)
6.1.7221.0	RTM
6.1.7221.13	RTM with CU1 Applied
6.1.7221.15	RTM with CU2 Applied
6.1.7221.49	RTM with CU3 Applied
6.1.7221.61	RTM with CU4 Applied
6.1.7221.81	RTM with CU5 Applied
6.1.7221.99	RTM with CU6 Applied
6.1.7221.110	RTM with CU7 Applied

Configuration Manager 2012 RC now supports SQL 2008 R2

As of 03/12/11 you'll be pleased to know that SQL Server 2008 R2 Service Pack 1 is now supported for use with Configuration Manager 2012 Release Candidate 1. 

In addition to Service Pack 1, you will also need to install Cumulative Update 3 (CU3) for SQL Server 2008 R2 SP1, as well as the hotfix described in KB2603910: http://support.microsoft.com/kb/2603910.

However, please note that the hotfix for SQL 2008 R2 has currently been pulled again for some reason and isn't available at the link above, I'll update this post when it is, until then you would need to contact MS to obtain the hotfix.

*Updated 12/12/11* The hotfix for SQL 2008 R2 is now available.  Thanks Mr Anonymous commentor.

How to move a SCVMM 2012 database to another SQL server

I'm not exactly re-inventing the wheel here as it's the same process for Virtual Machine Manager 2012 as it was for 2008 R2, but I thought I'd post about it anyway.

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:

1. Take a snapshot of the server (assuming it's a VM)
2. Take a backup of the existing VMM DB
3. Uninstall VMM and choose the Retain Database option
4. Detach the VMM DB from the local SQL instance
5. Copy the VMM DB files across to the new SQL Server
6. On the remote SQL server, attach the VMM db
7. Re-install SCVMM 2012 and when prompted, point it at the new SQL server, selecting to use an existing database (the one you imported) 

Easy!  Now you're free to uninstall SQL as and when.