vCenter service Fails to start - Error Code 2

[Tibmeister]

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

[krowczynski]

Try this one.

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

MCP, VCP

[Tibmeister]

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.