VMware Cloud Community
mnisadmin
Contributor
Contributor

max size of sql database

Hi,

I have VC 4.1.0 Build 345043 with defaul SQL server db.

I want to know if the db has a max file size limit of 4G ?

if so what is the alternative ??

I have reduced the db retention policy to 30 days

anything else I can do ensure the db is not full ??    

0 Kudos
3 Replies
idle-jam
Immortal
Immortal

yes the max is 4GB for MsSQL Express edition. have a look at this thread one how to clean up. http://communities.vmware.com/message/951217  Anyway there is a calculator and if you're within 3-4 hosts it will hardly get full.

mnisadmin
Contributor
Contributor

I have 5 hosts and the file gets full.

the calculator in the other thread is for VC2.0

can I not add another datafile to the db ?     

0 Kudos
Rubeck
Virtuoso
Virtuoso

You can also purge some of the performance data from your vCenter DB described in this KB article here:  http://kb.vmware.com/kb/1025914

/Rubeck

0 Kudos