SQL Error message (table corrupt)

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

I ran a DBCC on a database and I received errors for different tables with the following error numbers.

8977 8978

However when I checked the MSDN lib it did not give any description. Please explain the above error and the solution for it

Thanks

Anil

-- Anonymous, November 18, 2001

Answers

Anil,

When you have corruption, your best bets are, in this order, to restore from backup, call Microsoft Product Support Services, or try running checkdb with the fix options. You will probably also want to install the latest service pack to obtain the latest bug fixes.

The following URL (all on one line, with no spaces) explains the details on contacting Product Support Services:

http://support.microsoft.com/directory/content.asp?ID=FH;EN- US;offer11A&FR=0&SD=GN&LN=EN-US&CT=SD&SE=NONA

Hope this helps,

Eric

-- Anonymous, November 19, 2001


Moderation questions? read the FAQ