vCenter

 View Only

  • 1.  vCenter service Fails to start - Error Code 2

    Posted Oct 06, 2009 05:36 PM

    After upgrading my DB from Virtual Center 2.5 to vCenter 4, everytime I reboot the DB goes into Recovery Mode, which causes vCetner to stop for a while. I am beating my head against the wall trying to figure this out.

    Windows 2003 Enterprise Server SP2

    SQL Server 2005 Standard (On Box)

    Simple Recovery Mode

    Auto-Grow Files

    33.8GB free on partition



  • 2.  RE: vCenter service Fails to start - Error Code 2

    Posted Oct 06, 2009 05:52 PM

    Try this one.

    http://www.vmware.com/files/pdf/vc_microsoft_sql_server.pdf

    MCP, VCP



  • 3.  RE: vCenter service Fails to start - Error Code 2

    Posted Oct 06, 2009 06:34 PM

    DBCC SHOWCONTIG scanning 'VPX_HIST_STAT' table...

    Table: 'VPX_HIST_STAT' (677577452); index ID: 3, database ID: 5

    LEAF level scan performed.

    - Pages Scanned................................: 0

    - Extents Scanned..............................: 0

    - Extent Switches..............................: 0

    - Avg. Pages per Extent........................: 0.0

    - Scan Density .......: 100.00%

    - Logical Scan Fragmentation ..................: 0.00%

    - Extent Scan Fragmentation ...................: 0.00%

    - Avg. Bytes Free per Page.....................: 0.0

    - Avg. Page Density (full).....................: 0.00%

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.