Hi,
I got the following report thru our dbcc script : could you please advise what should next be done :
Checking test_db: Logical pagesize is 2048 bytes
Storage checks for 'test_db' are complete. DBCC is now recording the results in the dbccdb database.
DBCC CHECKSTORAGE for database 'test_db' sequence 71 completed at Oct 27 2009 11:46AM. 1 faults and 23 suspect conditions were located. 0 checks were aborted. You should investigate the recorded faults, and plan a course of action that will correct them.
Suspect conditions are to be treated as faults if the same suspect condition persists in subsequent CHECKSTORAGE operations, or if they are also detected by other DBCC functions.
(1 row affected)
Verifying faults for 'test_db'.
DBCC CHECKVERIFY for database 'test_db' sequence 71 completed at Oct 27 2009 11:46AM. 0 suspect conditions considered, 0 identified as faults, 0 identified as harmless, and 0 could not be checked. 0 objects could not be checked.
ERROR: Hard error count = 1
ERROR: Soft error count = 23
(return status = 0)
Database test_db: running sp_dbcc_run_faultreport short and long
Msg 18491, Level 16, State 1:
Server 'SYB_PROD', Procedure 'sp_dbcc_run_faultreport',
Line 1127:
No fault report on DBCC operations available.
(return status = 1)
Msg 18491, Level 16, State 1:
Server 'SYB_PROD', Procedure 'sp_dbcc_run_faultreport',
Line 1127:
No fault report on DBCC operations available.
(return status = 1)
