Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chris_wood99
Yak Posting Veteran
70 Posts |
 Posted - 2006-03-03 : 06:49:32
|
| Error: 845, Severity: 17, State: 1 spid7 Time-out occurred while waiting for buffer latch type 4 for page (8:68526), database ID 7..I have started to receive these errors from SQL a server 2000 sp3a box.The threads i've read refer to AWE memory settings but i don't use AWE memory settings.The strange thing is that the server was rebooted last night and the scheduled jobs began to work again but kicked up this problem after 3 hours or so. |
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2006-03-03 : 08:33:47
|
| Are you using shrinkdb or shrinkfile at the time you are receiving this error? |
 |
|
|
kpsreenath
Yak Posting Veteran
52 Posts |
Posted - 2006-03-03 : 08:52:00
|
| Please take a look at this microsoft site.http://support.microsoft.com/kb/811052 |
|
|
|
chris_wood99
Yak Posting Veteran
70 Posts |
Posted - 2006-03-07 : 06:12:45
|
no afraid not. i have also seen this article but i started to receive the error when sql server was attempting a tran log backup. This error now occurs whenever sql server is attempting to run scheduled transaction log or full backup.I now am faced with a DBA nightmare! having to reboot the server without having a backup of last nights data first.  |
|
|
|
|
|
|
buffer latch type 4 error causing jobs to fail