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
 SQL Server Administration (2000)
 Buffer Latch Time-out: Shrinking database

Author  Topic 

sumwanlah
Starting Member

43 Posts

Posted - 2003-04-03 : 03:18:13
Hi guys

Encountered this error whenever I try to shrink my primary filegroup, which only has a single file. This error doesn't occur with other files/filegroups.

Right now, the primary filegroup has oodles of space I'm trying to reclaim, but it's driving me nuts!!!!

What can anyone do about this? I've even tried creating a new file into the same filegroup and run the DBCC command with emptyfile option, but I get the same error.

Here's the error message below:
Message Text
Time-out occurred while waiting for buffer latch type %d for page %S_PGID, database ID %d.

Explanation
When under a heavy stress load or high I/O conditions, your system may produce this message.


------------------------
What goes around...? Is the belt around my waist!

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2003-04-03 : 08:45:07
HTH...

[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;811052[/url]
[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;811205[/url]

Sekar
~~~~
Success is not a destination that you ever reach. Success is the quality of your journey.
Go to Top of Page
   

- Advertisement -