While checking the POST database error shown below comes.
DBCC results for POST database :
CHECKDB found 0 allocation errors and 4 consistency errors
in table 'DCL.rddflt' (object ID 30623152).
CHECKDB found 0 allocation errors and 1 consistency errors
in table 'DCL.rdibb' (object ID 62623266).
CHECKDB found 0 allocation errors and 4 consistency errors
in table 'DCL.rdindex' (object ID 94623380).
CHECKDB found 0 allocation errors and 2 consistency errors
in table 'DCL.nomineeinfo' (object ID 130099504).
CHECKDB found 0 allocation errors and 22 consistency errors
in table 'DCL.rdjrnl' (object ID 158623608).
CHECKDB found 0 allocation errors and 2 consistency errors
in table 'DCL.nsc_other_office_certs' (object ID 610101214).
CHECKDB found 0 allocation errors and 37 consistency errors
in table 'DCL.print_passbokdet' (object ID 1257823593).
CHECKDB found 0 allocation errors and 2 consistency errors
in table 'DCL.nsc_addrbook' (object ID 1627152842).
CHECKDB found 0 allocation errors and 3 consistency errors
in table 'DCL.ledger' (object ID 1925581898).
CHECKDB found 0 allocation errors and 8 consistency errors
in table 'DCL.accountopen_through_agent' (object ID 1977058079).
CHECKDB found 0 allocation errors and 2 consistency errors
in table 'DCL.rdbulk_ledger' (object ID 2146106686).
CHECKDB found 0 allocation errors and 87 consistency errors
in database 'POST'.
Solution given by SDC chennai is given below.
The problem relates to corrupted
tables in the POST database.
Take the backup of POST database.
Run the query given below from
SQL Query Analyser after taking a backup. Run the queries one by one. On
successful execution of first query, you run the second query. After running
the second query run third query. For each set of queries, copy down the results and send it to
us.
Also ensure that all users are
logged out of sanchaypost.
sp_dboption 'post', 'single
user', 'true'
go
dbcc checkdb ('post',
REPAIR_REBUILD)
go
sp_dboption 'post', 'single
user', 'false'
go
After this, once again run
'DBAnalyzer >> DB Utilities >> Check database consistency' for POST
database and intimate results.
