[Last Call] Learn how to a build a cloud-first strategyRegister Now


VMWare VCenter 4.0

Posted on 2011-10-07
Medium Priority
Last Modified: 2012-08-13

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.

Question by:tech2010
  • 3
  • 2
LVL 124
ID: 36931719
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.
LVL 124
ID: 36931732
How big is the current database, and do you want to keep existing performance database, events, logs and layouts, and resource pools?
LVL 16

Expert Comment

by:Danny McDaniel
ID: 36934848
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.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 36942238
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.

LVL 124
ID: 36942434
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.
LVL 16

Accepted Solution

Danny McDaniel earned 2000 total points
ID: 36944048
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
Teach the user how to use configure the vCenter Server storage filters Open vSphere Web Client:  Navigate to vCenter Server Advanced Settings: Add the four vCenter Server storage filters: Review the advanced settings: Modify the values of the four v…
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question