I'm getting the below error while insert record into a SQL 2005 SP3 DB.
Msg 845, Level 17, State 1, Line 1 Time-out occurred while waiting for buffer latch type 3 for page (1:401831), database ID 8.
What does "page (1:401831)" refer to is this a memory allocation or a disk allocation?
Reason I'm asking is that the errors always refer to the same page. Removing the record being inserted resolves the issue for a while, but then appears again for a different record.
As such I believe that whatever the page refers to is corrupted and SQL can't read from it.
The record being inserted is pulled from a remote OLTP SQL server to a DataWareHouse server, failing in on the DWH server. Another DWH server copied the same record fine.
Thank you!