how to change vCenter database from default location to another drive?

[rManic]

Hi

I have installed vc with sql 2005 express, now my vCenter server c:\ is almost full

is it possible to move my vCenter database to another drive

regards

Manic

[MSVijay]

It is possible.

There are some workaround available. Pls refer KB:7960893.

Cheers,

VJ

[krowczynski]

Hi,

you can install a new server with more space and migrate the data as following.

http://kb.vmware.com/selfservice/microsites/search.do?cmd=displayKC&docType=kc&externalId=5850444&sl... 0 67947138

But you can use also tolls like gparted or dell_expart to incrase your space.

MCP, VCP

[rManic]

thanks

will it affect my running VM's and ESX Server attached? any idea?

regards

Manic

[MSVijay]

It is not going to affect the running VMs and also ESX but you/VSC may see a disconnect for a while.

Regards,

VJ

[rManic]

hi krowczynsk

I planned to move VIM_VCDB to another another drive (d:\) .As my vCenter running in a VM ,It will be very easy for me to exdent my virtual HDD and create another volume to accomedate VC DB

do I have to follow the same method ?

regards

Manic

[rManic]

hi VJ

thanks for your quick response

Do you have any idea on how max DB size SQL 2005 express support for virtual center?

regards

Manic

[MSVijay]

It is actually 4 GB but you may want to try with couple of DB files if there is a requirement.

Wish to hear the result though..!

Regards,

VJ

[rManic]

when I do detach db as given in the KB I received the following message

can not detach VIM_VCDB as it is currently in use

any help?

regards

Manic

[MSVijay · Accepted solution]

It is really interesting.....!

Please try with GUI. Right Click the DB -> Tasks -> Detach -> Select "Drop Connections"

Then "Check" "Drop Connections" and click OK.

Share the results...!

Cheers,

VJ

[rManic]

Thank you so much guys

it is working.....

thanks

manic

[Kahonu84]

Aloha,

Related question. I have a 4 host ESX 3.5U4 system.My VCenter is pointing to an external SQL server. I am about to upgrade to vSphere and want to have the SQL running on on the VCenter server itself - most likely using SQL Express. I have the same concern about space. Is there a way to limit the size of the database???

Mahalo, Bill

[rosensharma]

--

[GG42]

A different approach would be to extend the c-drive.

We have recently released a tool (fatVM) to make this easy (or easier).

It creates the extended VM in a new directory (with the original as parent). Does not touch the original files. Is able to extend most VM in a couple of minutes.

Here is the link: http://www.gudgud.com/fatvm

Regards

[rManic]

You have only 4 ESX ,so it is good idea to use SQL Express as it is free it will support max 4 GB database size.

follow the steps in the following KB's

http://kb.vmware.com/selfservice/microsites/search.do?cmd=displayKC&docType=kc&externalId=5850444&sl...

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=796089...

to detacch and attach database use steps given by vijay on the same discussion above

regards

Manic