sql server mseq: Hi All,

Could someone please tell me how to fix the following
error? This error is appearing on several tables for 2
weeks now. I already ran a complete hardware diagnostics
on the server and it is cleaned. Please help, I am
getting desperate.

Server: Msg 2535, Level 16, State 1, Line 0
Table Corrupt: Page (1:566656) is allocated to object ID
1189579276, index ID 255, not to object ID 798625888,
index ID 5 found in page header.

Thanks,

Hi,

What is the version/edition of SQL Server you are using. Did you patched the
SQL server with latest service pack?

Did you tried the below steps:-

1. Perform a complete backup of the database and kleep it in safe place
2. Set the database to sincle user mode (Alter database <dbname> Single_user
with rollback immediate)
3 Ensure that TEMPDB have enough space, because DBCC CHECKDB uses tempdb
4. Execute DBCC CHECKDB with REPAIR_REBUILD option

Note:
If the abobe steps fail then you need to restore from good backup or contact
Microsoft Support.

Look into the below article for the cause of this error:-
http://support.microsoft.com/default.aspx?scid=kb;en-us;276992


Thanks
Hari
MCDBA


[quoted text, click to view]