Sanchay Post databases Consistency Issue and Solution .

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.