vcptobe
Enthusiast
Enthusiast

Issue with SQL 2008 Express R2

Have an issue where logs have been shrank but customer is using SQL Express

Any workarounds with this? Other than migrating or upgrading to SQL Server Standard 2008 R2

See enclosed screenshot is it possible to change this to 10000 in the primary field

I know 10GB is limit for SQL 2008 R2

If someone could go through options that would be great,

0 Kudos
3 Replies
A13x
Hot Shot
Hot Shot

I do not see the issue with logs that have been shrunk? If logs are an issue just stick the database into simple mode.

What are the chances of you actually using the logs in recovery etc

0 Kudos
GayathriS
Expert
Expert

I beilive the option is to truncate the EVENT DB , before that Can I know which version of VC ( and this VC is been mapped to this DB correct)

regards

Gayathri

0 Kudos
Vijay2027
Expert
Expert

In my case I had to truncate tasks and events when using SQL Express edition.

Truncate the event and tasks table

To Truncate the event and tasks table, run this script:

alter table VPX_EVENT_ARG drop constraint FK_VPX_EVENT_ARG_REF_EVENT, FK_VPX_EVENT_ARG_REF_ENTITY
alter table VPX_ENTITY_LAST_EVENT drop constraint FK_VPX_LAST_EVENT_EVENT
truncate table VPX_TASK
truncate table VPX_ENTITY_LAST_EVENT
truncate table VPX_EVENT
truncate table VPX_EVENT_ARG
alter table VPX_EVENT_ARG add constraint FK_VPX_EVENT_ARG_REF_EVENT foreign key(EVENT_ID) references VPX_EVENT (EVENT_ID) on delete cascade,
constraint FK_VPX_EVENT_ARG_REF_ENTITY foreign key (OBJ_TYPE) references VPX_OBJECT_TYPE (ID)
alter table VPX_ENTITY_LAST_EVENT add constraint FK_VPX_LAST_EVENT_EVENT foreign key(LAST_EVENT_ID)
references VPX_EVENT (EVENT_ID) on delete cascade

Ref: VMware Knowledge Base

0 Kudos