Tuesday, 5 February 2013

Time out occurred while waiting for buffer latch -- type 3, bp 0000000081FEE180, page 1:824976, stat 0xc0000b, database id: 8, allocation unit id: 6488064



Problem:

We found the error message in the sql server error log(SQL Server 2008 R2).

Error message 1:
 
Time out occurred while waiting for buffer latch -- type 3, bp 0000000081FEE180, page 1:824976, stat 0xc0000b, database id: 8, allocation unit id: 6488064, task 0x00000000043B8988 : 0, waittime 1892400, flags 0x100000003a, owning task 0x00000000043B8988. Continuing to wait.

Error message 2:

Also we are unable to run the full backup of one particular database.


Resolution :

Problem resolved after apply Sp2 SQL server 2008 R2 patch.



http://support.microsoft.com/kb/2545989





No comments:

Post a Comment