SQL Server Performance Forum – Threads Archive
DBCC CHECKDB return ErrorsEnvironment:
SQL Server 2K sp3a Producr version 8.00.818 on Windows Server 2K3 – 2 nodes MSCS Cluster (Single instance).
We have Maintenance Plan scheduled and every week a Database Integrity Check is running thru a job on all of our databases.
This was done before, for at least 4 years on SQL Server 7 on a NT4 MSCS CLuster and now for at least 1 year on the new HW and SW platform.
Never had any problem since now when I received the following errors: DBCC CHECKDB (SOI_Abitanti_PROD01) executed by LUGANOSQL-Service found 1 errors and repaired 0 errors. [Microsoft][ODBC SQL Server Driver][SQL Server]Object ID 2048062382, index ID 0: Page (1:15733) could not be processed. See other errors for details.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in table ‘presenza’ (object ID 2048062382).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in database ‘SOI_Abitanti_PROD01’.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss i When I saw this error I just re-check the database with DBCC CHECKDB but this time there was no errors anymore.
What could be the cause of that?
Do I have to worry about this? You also may have to consider the following: 1)this database is no more updated, it’s just a read only database for history purpose.
2)We recently have installed Lotus Domino 6.5.3 (1 month ago)
3)We recently upgraded from IBM DIrector version 4.12 to version 4.21. (1 month ago)
Ensure the harddisk has no issues where the data files are located.
In order to repair the DBCC CHECKDB consistency error follow the process defined in the books online. If its a ready only database then I wouldn’t worry much about it and ensure the DBCC checks and reindexing job is running without any issues. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Satya, thank you very much for your time.