Tuesday, September 30, 2014

2)
Application event log – Microsoft SQL Server Native client could
not allocate space for the object <object_name> in database
<database_name> because PRIMARY file group is full. Create disk space by
deleting uneeded files, dropping objects in the filegroup, adding additional
files to the filegroup or setting autogrowth on for existing files in the
filegroup.

SCOPE

VCenter server having its
database running on the local server Microsoft SQL Express edition.

Note:

1) SQL Express edition has
a limitation of 10GB per database.

2) There are many reasons
for vCenter server service not starting and this is one of the reasons.

DESCRIPTION

VMware vCenter Server
stores performance, tasks & event logs data in the vCenter Server database.
Over time, data collection results in growth of the database files and a
mechanism is needed to shrink these files

VMware vCenter Server has
a Database Retention Policy setting that allows you to specify when vCenter
Server tasks and events should be deleted. Because this setting does not affect
performance data records, it is still possible to purge or shrink old records
from the database.

Due to this, if vCenter
database has reached the limit and database free space is very low, VMware vCenter
server service fails to starts (or) keeps starting and stopping frequently.

PROCEDURE

1) Stop the vCenter Server services if it keeps starting and stopping
frequently.

2) Open Microsoft SQL Server Management Studio.

a.
Server type – Database Engine

b.
Server name – <database_server_name>\<database_name>

c.
Authentication – Windows Authentication

3)
You can check the database free space, by connecting to the
database using Microsoft SQL Management Studio. Select the database -> click
properties -> Select "General". You can see the space available in
the database (as shown below).

4) Before purging the unwanted data (Event logs) from the database, we need to take a backup of the vCenter database.

13) Verify the database free
space, by connecting to the database using Microsoft SQL Management Studio.
Select the database -> click properties -> Select "General".
You can see the free space available in the database.