SANCHAY POST DATABASES CONSISTENCY ISSUE AND SOLUTION

SQL Databases Consistency Error And Solution

In most of the time SQL database shows error or not accessible while we check database using DBCC, it shows consistency error.

Example:

DBCC results for SIGN database : 

CHECKDB found 0 allocation errors and 125 consistency errors in table 'DCL.scan_record_table' (object ID 1977058079).

CHECKDB found 0 allocation errors and 125 consistency errors in database 'SIGN'

Solution

1. The problem relates to corrupted tables in the SIGN database.
2. Run the  query given below from SQL Query Analyser after taking a backup.
3. Run the queries one by one. On successful execution of first query, you run the second query.  On successful execution of first query, you run the second query. After running the second query for each set of queries, copy down the results and send it to us.
4. Also ensure that all users are logged out of sanchaypost.

sp_dboption 'SIGN', 'single user', 'true'
go

dbcc checkdb ('SIGN', REPAIR_REBUILD)
go

sp_dboption 'SIGN', 'single user', 'false'
go

After this, once again run 'DBAnalyzer >> DB Utilities >> Check database consistency' for SIGN database.

If any issue with above query kindly contact SDC Chennai

Source : http://potools.blogspot.in/