August 4, 2003 at 12:03 am
Hi
Yesterday couple of my database backups failed with the following message:
Time-out occurred while waiting for buffer latch type 4 for page (2:0), database ID 13. [SQLSTATE 42000] (Error 845) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Microsoft tech note talks about an AWE setting which may cause this. But I DONT
have any AWE setting...
Any one could help me out finding the source of this error please....
August 4, 2003 at 10:10 am
Check your machine application and system logs. You may have some kind of hardware issues with the RAID disks.
August 4, 2003 at 11:01 am
I did check the event logs. Nothing suspicious
August 6, 2003 at 7:28 am
Sounds like the backup routine can't read pages form the DB. Like Allen said, I'd check your disks first. Run a consistency check or a CHKDSK. Also, run a DBCC CHECKDB to make sure you don't have any corruptions.
August 6, 2003 at 10:09 am
CHKDSK and DBCC CHECKDB didnt return any errors
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply