VMware vSphere

 View Only
  • 1.  Issue with SQL 2008 Express R2

    Posted Aug 16, 2018 07:49 AM

    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,



  • 2.  RE: Issue with SQL 2008 Express R2

    Posted Aug 16, 2018 07:59 AM

    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



  • 3.  RE: Issue with SQL 2008 Express R2

    Posted Aug 16, 2018 08:03 AM

    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



  • 4.  RE: Issue with SQL 2008 Express R2

    Posted Aug 16, 2018 08:04 AM

    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