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
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