RSS

Could not allocate space for object dbo.VPX_EVENT.. because database size would exceed your licensed limit

22 Jul

vcenter will not start.
Erros on events logs:
Could not allocate space for object dbo.VPX_EVENT
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.
Because: SQL Express 2005 have limit 4GB for 1 Database and 2008 Express have limit to 10GB for 1 Database.

Install (free) Microsoft SQL Server Management Studio Express

http://www.microsoft.com/download/en/details.aspx?id=8961

Stop all vmware* services

From Management studio, connect to right server name and then select Database for vcenter (VIM_VCDB)

And run (will delete events and task logs):
SELECT @RowCount=count(*) FROM [VIM_VCDB].[dbo].[VPX_TASK]
WHILE @RowCount > 0
BEGIN
DELETE TOP (20000) FROM VIM_VCDB.dbo.[VPX_TASK]
DBCC SHRINKFILE (N'VIM_VCDB_log' , 0, TRUNCATEONLY)
SELECT @RowCount=count(*) FROM [VIM_VCDB].[dbo].[VPX_TASK]
END
SET @RowCount = 0
SELECT @RowCount=count(*) FROM [VIM_VCDB].[dbo].[VPX_EVENT]
WHILE @RowCount > 0
BEGIN
DELETE TOP (20000) FROM VIM_VCDB.dbo.[VPX_EVENT]
DBCC SHRINKFILE (N'VIM_VCDB_log' , 0, TRUNCATEONLY)
SELECT @RowCount=count(*) FROM [VIM_VCDB].[dbo].[VPX_EVENT]
END

(from: http://www.creativecodedesign.com/node/59)

Shrink database (right click on db>tasks>shriink>Database

Start Vmware* services

connect to vcenter

Change performance statistics settings in vCenter that not that much data is collected.
vCenter > Administration > vCenter Server Settings and select Statistics
vCenter > Administration > vCenter Server Settings and select Database Retention Policy

About these ads
 
Leave a comment

Posted by on July 22, 2011 in howto

 

Tags: , , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

%d bloggers like this: