Recover / Repair Counter database in SQL

To resolve, follow the steps

• Take backup of Counter database and close all the application which are using. 
• Run the below SQL queries in Microsoft SQL server management studio line by line 

USE master ALTER DATABASE counter
SET single_user
DBCC checkdb ('counter','repair_rebuild')

Also read :Error 601: Could not continue scan with NOLOCK due to SQL Server data movement

DBCC checkdb ('counter','REPAIR_FAST')
DBCC checkdb ('counter','repair_allow_data_loss')

Also read :Shrink Query For SQL 2008 R2 (Single Database Shrink Query)

ALTER DATABASE counter
SET multi_user use Counter dbcc checkdb 

• In the Message, last line shows the allocation errors and consistency errors, if this is 0 means, your database is recovered. 
• Take backup of counter database again and use the  despatch application now.