Problem with reindexing SQL database for MS CRM
Posted on 2008-10-09
I am seeing the error below in my logs and have tried to run the DBCC Checkdb command on the database. I could use assistance from someone who knows SQL much better than me.
Host CLARITYSBS: error while processing organization f610b1b2-084e-42c8-a48f-a4bbc5cd7b60. Exception: System.Data.SqlClient.SqlException: Unable to find index entry in index ID 4, of table 1724585232, in database 'Clarity_MSCRM'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support.
A severe error occurred on the current command. The results, if any, should be discarded.
I then open SQL Studio and run the following command:
ALTER DATABASE Clarity_MSCRM SET SINGLE_USER
Dbcc Checkdb('Clarity_MSCRM', Repair_Rebuild)
ALTER DATABASE Clarity_MSCRM SET MULTI_USER
I then get the following result:
DBCC results for 'Clarity_MSCRM'.
Msg 8921, Level 16, State 1, Line 2
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
DBCC results for 'sys.sysrowsetcolumns'.
There are 6763 rows in 69 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
Msg 1105, Level 17, State 2, Line 2
Could not allocate space for object 'dbo.SORT temporary run storage: 140737741324288' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Msg 9002, Level 17, State 4, Line 2
The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
I cannot find the tempdb referenced above. I have looked at the database and its set to unlimited size, along with the log files.
SQL is not my strong area, so I'm limited to figureing this out.