Search This Blog

Wednesday, October 20, 2010

Change VMM SQL Express With SQL Standard

We always start to install System Center Virtual Machine Manager (VMM) with SQL Express. One day, you will realise that SQL Express can't cope when you have added more Hyper V Host and Virtual Machine. By default SQL Express database size is limited to 4GB.

Then it's the time to replace SQL Express with SQL Server Standard Edition. The process is quite simple and here is the step that you should take:

1. Uninstall VMM Server. Make sure you select "Retain data" to maintain the VMM database.
2. Uninstall SQL Express 2005 component.
3. Install SQL Server 2008 Standard Edition and Service Pack.
4. Copy VirtualManagerDB and VirtualManagerDB_log from C:\Program Files(x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data. to C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLServer\MSSQL\Data.
5. Use SQL Server Management Studio to Attach the database.
6. Install VMM Server Component and use existing database.
7. Once complete the installation, verify that everything is intact.

So far, Host refresh, Virtual Machine management, VMM Library, Integration with SCOM, etc is working without any problem.

[Updated: 21 Oct 2010]
By default, VMM 2008 R2 came with SQL Server 2005 Express Edition with SP3.The default limit is 4GB.

You can follow the above step 1-7 to migrate to SQL Server 2008 R2 Express edition. This will allow you to have 10GB database limit.I have tested this scenario and it is working like a charm.

3 comments:

  1. Hi,
    you know that SQL 2008 R2 Express has a default limit of 10 GB?
    And yes, SQL 2008 R2 is currently not officially supported with VMM 2008 R2.

    --
    Peter Forster, MVP Virtual Machine, Austria

    ReplyDelete
  2. Hi,

    Thanks Peter for the highlight. Using the CD provided, setup will install SQL Server 2005 Express with SP3 which has a limit to 4GB.

    As mentioned by Peter, SQL 2008 R2 Express has increased the default limit from 4GB to 10GB. To the other visitor,for more detail please refer to http://www.microsoft.com/express/Database/

    On the SQL 2008 R2 Express support, it is supported as mentioned in http://technet.microsoft.com/en-us/library/cc764220.aspx

    Only VMM 2008 R2 is supported however it is still no reporting supported when using SQL Express.

    Gosh, never thought about R2 Express.

    ReplyDelete