SQLTeam.com | Weblogs | Forums

Could not read and latch page (1:1370) with latch type SH. sysindexes failed


#1

"Dbcc checkdb showed a database to have consistency errors, however running repair_allow_data_loss resulted in the following error

Server: Msg 8966, Level 16, State 1, Line 2
Could not read and latch page (1:1370) with latch type SH. sysindexes failed.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Please could you tell me how to fix it, and how it occurred in the first place?

Thanks"


#2

Run hardware diagnostics and correct any problems this may due to hardware failure or due to any hardware related problem. If there is no problem in hardware then restore database from recent backup.
and If no recent backup available you may use Repair_Allow_Data_Loss which I will recommend not to as using this command can cause loss of your valuable data and this command is used at last resort when data is not important. Best option is you may try SQL Server database repair tool. Which will repair your error and you may get your valuable data.