VMWare VCenter 4.0


We are running vmware vsphere ESX 4.0 and Vcenter database is on SQL 2005 enterprise on seperate vmware machine. My question we can move vcenter database from SQL 2005 enterprise to SQL 2005 Express. This is purely because of license reason as we have not SQL license so wondering if we can move the database to express edition. Is it possible if yes are there any implications i should be considering and finally how to do this.

Who is Participating?
Danny McDanielConnect With a Mentor Clinical Systems AnalystCommented:
if you are using Update Manager, it may have a separate db so copy it and change the DSN for it, too.  It's possible that you installed it and told it to use the same database as VC
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Yes, you can move it, however, using SQL Express is limited to a maxium of a 4GB database, so you may have to watch the size of your database, because a common issue, is vCenter Service stops because your database has grown beyond 4GB.
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
How big is the current database, and do you want to keep existing performance database, events, logs and layouts, and resource pools?
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Danny McDanielClinical Systems AnalystCommented:
SQL express is only supported if your environment is less than 5 hosts and 100 VM's and that will basically determine how large your database will potentially grow to.  if it is larger as stated previously, then you can shrink it down (usually, the size gets large because the rollup jobs aren't running through to completion).

If you have a small environment without DVS or SRM, and you don't mind losing your historical data for performance stats and tasks/events, then it is usually just quicker to do a clean install/re-install and create new database instance.  Then re-add your hosts and, if it's a new server, re-extract the sysprep files (if used for vm creation/cloning), configure HA/DRS and you're back in business with no VM downtime.  All of the datastore and network configurations are on the hosts and the VC will just query the hosts to put the info back into the database.
tech2010Author Commented:
Thanks both of you.

ok so what if i need to move vmware database from one SQL server enterprise to another SQL server enterprise. Is there any problem with that or is it just simple? Do i need to consider prior to migrate database? I am running HA and DRS and have 140 VMs running on 10 ESX hosts.

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
From damn66 posting, SQL Express would not be supported for your 140 VMs running on 10 ESX hosts.

But simply Detach, Copy you Existing Database from SQL Server to new SQL Server, Re-attach.

As for operation.

Stop the vCenter Service. (DRS will not function), but HA will continue as it does not require vCenter.

Change the ODBC reference to new Server.

Restart Service.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.