error 845

error 845

Post by nobob » Wed, 05 Dec 2001 22:13:57


The above mentioned error ocur since we have a high performance SAN attachet
to our database. The error will rise every night in the moment our
SQL-Server 7 make a full dump and concurrent a client try to make some

We gues that the Server do not have enougth time (because of the dump) to
handle the client request.

Does someone have seen this problem befor (and have a idea for a

thank you


error 845

Post by Neil Pik » Thu, 06 Dec 2001 03:18:56

 I assume you mean "

 845   17  Time out occurred while waiting for buffer latch type %d for page
%S_PGID, database ID %d, object ID %d, index ID %d."

 Do you have SP3 applied to SQL 7 already?  Your best bet would be to call this
in to MS PSS as it can't really be debugged via newsgroup support.

 MS will probably need a stack dump to see what is going on - see the
traceflagy FAQ entry for how to get one.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 ( in lib 7)