question

Sakthivel avatar image
Sakthivel asked

Issue on production server - Error Message 845

Hi DBA'S, I have one issue can you please tell me how to resolve that error. 1) SQL Error Msg 845, Level 17, State 1, Line 2 Time-out occurred while waiting for buffer latch type 2 for page (1:331), database ID 14. In that above error every day occur after that i restart the sql server it's work correctly i dont know how can i resolve this error can you please send me details
error-message
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What version of SQL Server?
0 Likes 0 ·

1 Answer

Fatherjack avatar image
Fatherjack answered
The online help for that error message is found here: http://www.microsoft.com/technet/support/ee/transform.aspx?ProdName=SQL%20Server&ProdVer=9.0&EvtID=845&EvtSrc=MSSQLServer&LCID=1033 Can you give us more detail about when the error occurs and what else is going on at that time on the server please?
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

In addition, you must also specify your SQL Server Edition and Service Pack as well. Besides, following is another good link http://support.microsoft.com/default.aspx?scid=kb%3BEN-US%3BQ310834
0 Likes 0 ·
Thank you for your response then every day 12pm that error was occurred First i was detach one database to another drive due to space problem after that every day that time(12pm) error will occur and i can not work with SQL Server then i restart the sql server its working fine and again next day 12pm error occurred can you please send me the details for how to resolve this error
0 Likes 0 ·
@Usman Butt - thanks for spotting that. Question closed
0 Likes 0 ·