SYMPTOMS
When you use SHRINKDB or SHRINKFILE or SQL Server Enterprise
Manager to reduce the size of a database on SQL Server 2000 Service Pack 2
(SP2) or later, the shrink operation runs for a long time (5 minutes or
longer), and then you receive the following error message:
2002-11-25 22:41:30.18 spid55 Time out occurred while waiting for
buffer latch type 4,bp 0x3d03340, page 1:37939357), stat 0xb, object ID 8:8:0,
EC 0xB39B55E0 : 0, waittime 300. Not continuing to wait.
2002-11-25
22:41:30.18 spid55 Waiting for type 0x4, current count 0x100022, current owning
EC/PSS 0xB39B55E0/0xB39B52B8.
Note The latch time-out message indicates a page in object 8 (for
example, 'object ID 8:8:0).
RESOLUTION
Service pack information
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack
Hotfix information
The English version of
this fix has the file attributes (or later) that are listed in the following
table. The dates and times for these files are listed in coordinated universal
time (UTC). When you view the file information, it is converted to local time.
To find the difference between UTC and local time, use the
Time Zone tab in the Date and Time tool in Control Panel.
Date Time Version Size File name
--------------------------------------------------------
18-Jan-2002 04:45 2000.80.568.0 29,244 Dbmslpcn.dll
30-Aug-2002 21:08 786,432 Distmdl.ldf
30-Aug-2002 21:08 2,359,296 Distmdl.mdf
09-Oct-2002 00:54 544 Drop_repl_hotfix.sql
02-Jul-2002 15:35 2000.80.650.0 107,088 Impprov.dll
19-Jul-2002 16:56 774,516 Instdist.sql
08-Oct-2002 23:56 12,615 Inst_repl_hotfix.sql
20-Aug-2002 16:24 2000.80.679.0 111,172 Logread.exe
25-Nov-2002 21:47 2000.80.707.0 90,692 Msgprox.dll
07-Apr-2002 02:08 2000.80.606.0 62,024 Odsole70.dll
03-Jan-2002 01:59 18,185 Qfe356326.sql
20-Aug-2002 16:47 2000.80.679.0 135,748 Qrdrsvc.exe
26-Aug-2002 22:49 2000.80.679.0 406,088 Rdistcom.dll
04-Oct-2001 01:36 437,302 Replcom.sql
20-Aug-2002 16:33 2000.80.679.0 152,136 Replmerg.exe
25-Nov-2002 21:43 1,004,990 Replmerg.sql
25-Nov-2002 21:47 2000.80.707.0 221,768 Replprov.dll
25-Nov-2002 21:47 2000.80.707.0 303,688 Replrec.dll
04-Oct-2001 01:36 986,906 Replsys.sql
04-Oct-2001 01:36 881,228 Repltran.sql
26-Aug-2002 22:49 2000.80.679.0 283,208 Rinitcom.dll
16-Sep-2002 22:31 390,045 Securityhotfix.sql
25-Nov-2002 19:14 53 Sp_vupgrade_replication.sql
26-Aug-2002 22:49 2000.80.679.0 28,672 Sqlagent.dll
26-Aug-2002 18:39 2000.80.679.0 311,872 Sqlagent.exe
28-Aug-2002 16:32 2000.80.679.0 49,152 Sqlagent.rll
26-Aug-2002 22:49 2000.80.679.0 53,824 Sqlcmdss.dll
28-Aug-2002 16:40 2000.80.679.0 12,288 Sqlcmdss.rll
24-Oct-2002 17:37 2000.80.695.0 176,696 Sqlmap70.dll
27-Nov-2002 19:43 2000.80.710.0 7,471,185 Sqlservr.exe
01-Nov-2002 18:56 2000.80.698.0 45,644 Sqlvdi.dll
18-Jan-2002 04:45 2000.80.568.0 29,244 Ssmslpcn.dll
23-Nov-2002 00:26 2000.80.706.0 82,492 Ssnetlib.dll
27-Nov-2002 01:14 2000.80.709.0 25,148 Ssnmpn70.dll
07-Apr-2002 02:08 2000.80.606.0 70,208 Xplog70.dll
07-Apr-2002 02:08 2000.80.606.0 53,828 Xpqueue.dll
07-Apr-2002 02:08 2000.80.606.0 156,228 Xprepl.dll
12-Jul-2002 01:00 2000.80.658.0 279,104 Xpstar.dll
16-Sep-2002 23:12 2000.80.686.0 98,872 Xpweb70.dll
NOTE: Because of file dependencies, the most recent hotfix or feature
that contains these files may also contain additional
files.