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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Buffer Latch Error

Author  Topic 

wilso_s
Starting Member

10 Posts

Posted - 2003-06-10 : 10:57:18
Has anyone experienced the following error? Microsft doesn't have any very informative information on this. Running SQL 2K with SP2 on Win 2K Adv Srv. No AWE.

WARNING: EC 42c043a0, 0 waited 300 sec. on latch 42cb19b0. Not a BUF latch.

One of the databases is in constant checkpoint. Because of this no log dumps can occur.

The only fix is to reboot the server and let the database go into self recovery mode.

Any Ideas?


tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-06-10 : 12:17:54
Have you searched MS's knowledge base yet? I got quite a few hits when I did. Just type in "Not a BUF latch" at [url]http://support.microsoft.com/[/url]. You'll need to go through all of the articles returned by the search and determine which one fits your environment. Then use the resolution of that article to fix it.

Tara
Go to Top of Page
   

- Advertisement -