Bonjour,
suite à des coupures électriques dans une de nos usines une table est corrompue : Time-out occurred while waiting for buffer latch type 2 for page (1:5856097)
j'ai identifié la table à partir des pages avant et après et effectivement je ne peux plus accéder aux rows récentes.
le dbcc checktable échoue : DBCC CHECKTABLE ('matable') WITH PHYSICAL_ONLY;
Msg 1823, Level 16, State 2, Line 1
A database snapshot cannot be created because it failed to start.
Msg 7928, Level 16, State 1, Line 1
The database snapshot for online checks could not be created. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.
Msg 5245, Level 16, State 1, Line 1
DBCC could not obtain a lock on object 269608399 because the lock request timeout period was exceeded.
Msg 845, Level 17, State 1, Line 1
Time-out occurred while waiting for buffer latch type 3 for page (1:5856097), database ID 5.
je tourne en rond ... si qqu a une idée :-)
sqlserver 2005, windows 2003
Partager