In SQL Server 2005
Whenever I run a:
ALTER DATABASE Solar SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (Solar , REPAIR_ALLOW_DATA_LOSS)
I get the following messages:
Msg 8930, Level 16, State 3, Line 1
Database error: Database 17 has inconsistent metadata. This error cannot be repaired and prevents further DBCC processing. Please restore from a backup.
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Is there a way to fix the inconsistent metadata or fix the tempdb without restoring from backup?