SQL Database Question

[Klove3]

I'm using SQL 2012 Standard for my vCenter 5.5 database. I have the recovery mode set to "Simple". I created the initial log of my database to 1GB and it's set to autogrow. My question is will this continue to autogrow until the disk runs out of space? Obviously we don't want that. What about the transaction logs? They are set to grow by 10% and also set as "unlimited".

Thanks for help.

[j_rodstein]

Hi Klove3,

The short answer is yes.  Your database does have the potential to autogrow and consume all space.  However, I have seen environments with 30 ESXi hosts and hundreds of VMs never exceed the database size of 15 gig.  Most of the growth occurs with error logging.  If you are concerned, set a hard limit, but I would not recommend doing so.

Hope this helps and if you need more details, I will be happy to assist.