Could not cleanup worktable IAM chains to allow shrink or remove file operation. Please try again when tempdb is idle

This is a multi-part message in MIME format.

------=_NextPart_000_0006_01CB1448.E88B1160
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi all,

I'm getting this message when trying to clear tempdb

DBCC SHRINKDATABASE (tempdb, 10) WITH NO_INFOMSGS=20

Msg 5054, Level 16, State 1, Line 1
Could not cleanup worktable IAM chains to allow shrink or remove file =
operation.  Please try again when tempdb is idle.
Msg 5054, Level 16, State 1, Line 1
Could not cleanup worktable IAM chains to allow shrink or remove file =
operation.  Please try again when tempdb is idle.

Other then restarting sql, is there another way to shrink the tempdb?

Thanks,

gv

------=_NextPart_000_0006_01CB1448.E88B1160
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18904">
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial>Hi all,</FONT></DIV>
<DIV><FONT face=3DArial></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial>I'm getting this message when trying to clear=20
tempdb</FONT></DIV>
<DIV><FONT size=3D2 face=3DArial></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff size=3D2><FONT color=3D#0000ff size=3D2>
<P>DBCC</FONT></FONT><FONT size=3D2> SHRINKDATABASE</FONT><FONT =
color=3D#0000ff=20
size=3D2><FONT color=3D#0000ff size=3D2> </FONT></FONT><FONT =
color=3D#808080=20
size=3D2><FONT color=3D#808080 size=3D2>(</FONT></FONT><FONT =
size=3D2>tempdb</FONT><FONT=20
color=3D#808080 size=3D2><FONT color=3D#808080 =
size=3D2>,</FONT></FONT><FONT size=3D2>=20
10</FONT><FONT color=3D#808080 size=3D2><FONT color=3D#808080=20
size=3D2>)</FONT></FONT><FONT size=3D2> </FONT><FONT color=3D#0000ff =
size=3D2><FONT=20
color=3D#0000ff size=3D2>WITH</FONT></FONT><FONT size=3D2> </FONT><FONT =
color=3D#0000ff=20
size=3D2><FONT color=3D#0000ff size=3D2>NO_INFOMSGS</FONT></FONT><FONT =
size=3D2>=20
</FONT></P></DIV>
<DIV>
<P><FONT face=3DArial>Msg 5054, Level 16, State 1, Line 1<BR>Could not =
cleanup=20
worktable IAM chains to allow shrink or remove file operation.&nbsp; =
Please try=20
again when tempdb is idle.<BR>Msg 5054, Level 16, State 1, Line =
1<BR>Could not=20
cleanup worktable IAM chains to allow shrink or remove file =
operation.&nbsp;=20
Please try again when tempdb is idle.</FONT></P>
<P><FONT face=3DArial>Other then restarting sql, is there another way to =
shrink=20
the tempdb?</FONT></P>
<P><FONT face=3DArial>Thanks,</FONT></P>
<P><FONT face=3DArial>gv</FONT></P></DIV></BODY></HTML>

------=_NextPart_000_0006_01CB1448.E88B1160--

0
gv
6/25/2010 1:29:27 PM
sqlserver.programming 1873 articles. 0 followers. Follow

1 Replies
3979 Views

Similar Articles

[PageSpeed] 41

This is a multi-part message in MIME format.

------=_NextPart_000_0014_01CB144D.F3A51230
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

this did it.
   =20
use tempdb
go
dbcc shrinkfile (tempdev, 5000)
go

thanks,

gv

=20

  "gv" <viator.gerry@gmail.com> wrote in message =
news:%23BZ7wpGFLHA.5736@TK2MSFTNGP02.phx.gbl...
  Hi all,

  I'm getting this message when trying to clear tempdb

  DBCC SHRINKDATABASE (tempdb, 10) WITH NO_INFOMSGS=20

  Msg 5054, Level 16, State 1, Line 1
  Could not cleanup worktable IAM chains to allow shrink or remove file =
operation.  Please try again when tempdb is idle.
  Msg 5054, Level 16, State 1, Line 1
  Could not cleanup worktable IAM chains to allow shrink or remove file =
operation.  Please try again when tempdb is idle.

  Other then restarting sql, is there another way to shrink the tempdb?

  Thanks,

  gv

------=_NextPart_000_0014_01CB144D.F3A51230
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18904">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial>this did it.</FONT></DIV>
<DIV><FONT color=3D#0000ff><FONT color=3D#0000ff><FONT color=3D#000000=20
face=3DArial>&nbsp;&nbsp;&nbsp; <BR>use tempdb<BR>go</FONT></DIV>
<DIV>
<P><FONT color=3D#000000 face=3DArial>dbcc shrinkfile (tempdev,=20
5000)<BR>go</FONT></P>
<P><FONT color=3D#000000 face=3DArial>thanks,</FONT></P>
<P><FONT color=3D#000000 face=3DArial>gv</FONT></P>
<P><FONT color=3D#000000 =
face=3DArial>&nbsp;</FONT></FONT></FONT></P></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; =
PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"=20
dir=3Dltr>
  <DIV>"gv" &lt;<A=20
  href=3D"mailto:viator.gerry@gmail.com">viator.gerry@gmail.com</A>&gt; =
wrote in=20
  message <A=20
  =
href=3D"news:%23BZ7wpGFLHA.5736@TK2MSFTNGP02.phx.gbl">news:%23BZ7wpGFLHA.=
5736@TK2MSFTNGP02.phx.gbl</A>...</DIV>
  <DIV><FONT face=3DArial>Hi all,</FONT></DIV>
  <DIV><FONT face=3DArial></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial>I'm getting this message when trying to clear=20
  tempdb</FONT></DIV>
  <DIV><FONT size=3D2 face=3DArial></FONT>&nbsp;</DIV>
  <DIV><FONT color=3D#0000ff size=3D2><FONT color=3D#0000ff size=3D2>
  <P>DBCC</FONT></FONT><FONT size=3D2> SHRINKDATABASE</FONT><FONT =
color=3D#0000ff=20
  size=3D2><FONT color=3D#0000ff size=3D2> </FONT></FONT><FONT =
color=3D#808080=20
  size=3D2><FONT color=3D#808080 size=3D2>(</FONT></FONT><FONT=20
  size=3D2>tempdb</FONT><FONT color=3D#808080 size=3D2><FONT =
color=3D#808080=20
  size=3D2>,</FONT></FONT><FONT size=3D2> 10</FONT><FONT color=3D#808080 =
size=3D2><FONT=20
  color=3D#808080 size=3D2>)</FONT></FONT><FONT size=3D2> </FONT><FONT =
color=3D#0000ff=20
  size=3D2><FONT color=3D#0000ff size=3D2>WITH</FONT></FONT><FONT =
size=3D2> </FONT><FONT=20
  color=3D#0000ff size=3D2><FONT color=3D#0000ff =
size=3D2>NO_INFOMSGS</FONT></FONT><FONT=20
  size=3D2> </FONT></P></DIV>
  <DIV>
  <P><FONT face=3DArial>Msg 5054, Level 16, State 1, Line 1<BR>Could not =
cleanup=20
  worktable IAM chains to allow shrink or remove file operation.&nbsp; =
Please=20
  try again when tempdb is idle.<BR>Msg 5054, Level 16, State 1, Line =
1<BR>Could=20
  not cleanup worktable IAM chains to allow shrink or remove file=20
  operation.&nbsp; Please try again when tempdb is idle.</FONT></P>
  <P><FONT face=3DArial>Other then restarting sql, is there another way =
to shrink=20
  the tempdb?</FONT></P>
  <P><FONT face=3DArial>Thanks,</FONT></P>
  <P><FONT face=3DArial>gv</FONT></P></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0014_01CB144D.F3A51230--

0
gv
6/25/2010 2:05:33 PM
Reply:

Similar Artilces:

NUL characters are not allowed
Hi, We have install the exchange 2003 and we are encountering intermitten problem when sending email to internet (only to a certain email domain other are alright). When that happens, we receive a "NUL characters ar not allowed" error. <mail.anonymous.com #5.5.0 smtp;550 Requested action not taken: NU characters are not allowed.> This error usually happens when we reply to a certain email domain. When this happens, we would retry 2 or 3 times, it usually i successfully after 2 or 3 tries. It only affects a small number of email domain. Other email domain ha no problem. H...

Embedded Excel file gridlines printing #2
I have an embedded Excel file in word and when I go to print, it i printing with the gridlines. In excel I have the gridlines turned of and it is still not working. HELP! Thank -- tanyhar ----------------------------------------------------------------------- tanyhart's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3514 View this thread: http://www.excelforum.com/showthread.php?threadid=55105 Open the Excel file in the Word document and turn off the gridlines. I it's still a problem, open the Excel file in the Word document an change the gridline colo...

GP and CRM servers
I am currently running three different servers. One server (Windows server 2003) is running Dynamics GP 10. This server also acts as my terminal services license server. Access to this server is via remote desktop and server access is via “Users and groups” settings (not Active Directory). My second server (Windows server 2003) is running CRM 4.0 and active directory. My third server (Windows Server 2008) will eventually be a SharePoint (MOSS 2007) server. I am in an academic environment and my three servers are running on top of VMware 2.5 ESX on IBM Blade hardware. I have no ...

Payroll should allow concurrent builds by different users
In a company that is heavy payroll, all checks are processed in the same day but by different users for different subsets of employees. Allowing concurrent builds would be nice. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolution...

read only form allows date to change
I have a form that I open in read only that has a calendar popup for the date fields. When I open the form the calendar pop up allows the date to be changed. The rest of the fields are read only. Any suggestions. Thanks Private Sub ViewActivityNote_Click() On Error GoTo Err_ViewActivityNote_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "FRM - Activity Note" stLinkCriteria = "[activitynoteid]=" & Me![activitynoteid] DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormReadOnly Exit_ViewActivityNote_Click: Exi...

Running File Level Virus Scanning on an E2K3 Front-End Server
Would it be fairly safe to install a File Level Virus Scanner (SAV 9.0) on a Win2K3 E2K3 SP1 Front End server that is only hosting OWA? There are no databases and the only Exchange related services running are: HTTP-Service, SMTP-Service, Exchange System Attendant, and Exchange Routing Engine. "MR-KEN" <kcarlini@netopia.com> wrote in news:#VF4lcRFFHA.628@TK2MSFTNGP15.phx.gbl: > Would it be fairly safe to install a File Level Virus Scanner (SAV > 9.0) on a Win2K3 E2K3 SP1 Front End server that is only hosting OWA? Yes, I wouldn't hesitate. You've heard of the...

Dependency File out of date
In the VB5 setup wizard, it lists 3 files with Out of date Dependencies, comdlg32.ocx, crystl32.ocx and comctl32.ocx. I have read about this in Google, but still have the following question using the "Comctl32.ocx" component(as an example) which is out of date. In Windows/System32, the OCX has a version of 6.0.81.5 but the dependency file for this ocx has a version of 6.0.80.22 listed. Since this a MS component, how do I know if there are new depencencies or if I just need to change the version number in the existing DEP file for this component?? Dep code shown bel...

My "Insert" button is not allowing me to type over text. Help??
Is there somewhere I can go to turn this on or off ?? Thx. Click the Insert/Overtype button on the Word 2007 status bar or Word Options > Advanced > Editing Options > Use the Insert key to control overtype mode. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> "jozee...

Disappearing graphics from publisher files
I have been working on documents for clients that have earlier version of MS Publisher. When I save them for their specific version of MS Publisher about 3/4 of the embedded graphics disappear. How can I get the graphics to stop disappearing? The graphics do not disappear when I save the file as a MS Publisher 2003 document. Amy, How were the embeded graphics created? - Were they imported ("insert", "Picture", "Clipart..."/"From File..."/"From Scanner or Camera...")? - Did they get pasted from another applications? - were the drawiin...

Excel files will not open from a shortcut in XP. How do I fix thi
Excell files set up as shortcuts will not open. The system sends a "file not found" message. The same thing occurs when trying to open anExcel attachment in an email. Other file types open normally (.doc, .dwg, .pdf, .jpg etc). How do I fix this so that I can open files from desktop shortcuts or from shortcuts in emails? I am using Windows XP Home Edition version 2002 Service Pack 1, and Excel 2003 (11.6355.6360) SP1 Sometimes one of these works: Tools|Options|General|Ignore other applications (uncheck it) --- or --- Close Excel and Windows Start Button|Run excel /unr...

Way to get folders in start menu to not expand to show all contents/files?
I use XP SP3, and the XP start menu (not the classic option). I have created a folder inside the All Programs menu, and I'd like this particular folder to not expand to show its contents--I do like this option for other folders in my All Programs menu, just not this one. Is there any way to customize a particular folder in the All Programs menu, so that its contents aren't displayed, although other folders do this? Assuming those links are only for you to use then I suggest move them from where they are to desktop and delete from where they currently are so that nothing will ...

disk cleanup deletes Money
Everytime I run my disk cleanup utility it deletes Money Express. Any ideas why this happens or how to prevent it? Thanks What is Money Express? Is it deleting the data files (designated by ????.MNY where ???? is the name of your Money files, assuming this is Microsoft Money). >-----Original Message----- >Everytime I run my disk cleanup utility it deletes Money >Express. > >Any ideas why this happens or how to prevent it? > >Thanks >. > oscar It probably realizes that Money Express is Totally useless. Bob "oscar" <anonymous@discussions.micros...

Help, can't shrink to fit so art prints on 1 page!
Working on a large banner, and want to share it with my team for review. Original file is 15mg, too large to send, and making a .pdf results in 45 pages of tiled images. Other desktop publishing software allows you to select a "fit to one page" or "scale" option so your image is reduced to one legal or letter sized sheet of paper. I can't even print this out to walk around and show my co-workers for comment. So - making a .pdf doesn't work, selecting Reduce then Fit to Paper Size won't work, asking to scale this to 20% won't work, printing to Offic...

Merging Files into a single PDF
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have installed Office Mac 2008, Home &amp; Student Edition, on a new Mac desktop computer along with Acrobat 9 Pro for Mac OS. In Acrobat, combine files, into a single pdf�word .doc and .docx files are not recognized for one step selection, conversion and merger. They must be converted to pdf first and one at a time. Acrobat can only combine and merge pdf's and many other file types but not Word. Adobe tells me that Office 2008 for Mac does not include a macro the allows for the select, convert and mer...

SumProduct in VBA
I have the following macro: Sub tracking() engid =3D "'[Export January.xls]Export_January'!$aq$2:$aq$43735" rev =3D "'[Export January.xls]Export_January'!$ag$2:$ag$43735" engid2 =3D Sheets("actual").Range("H4").Value If Not IsNumeric(engid2) Then engid2 =3D """" & engid2 & """" End If pct =3D Application.Evaluate("SUMPRODUCT(--(" & engid & "=3D" _ & engid2 & "),--(" & rev & "))") ThisWorkbook.Worksheets(&q...

are scripts allowed in exchange 2003?
I used to run a few scripts in exchange 5.5, and now that I'm upgrading to 2003 I can't find how to implement these scripts. How do I keep using my scripts from exchange 5.5 in exchange 2003? Can you give us a bit more information regarding your scripts? Are they VBS accessing WMI information, batch files utilizing resource kit (reskit) utilities, etc. Scripting works with Exchange 2003 and Active Directory...I tinker with VBScripts. I have also used batch scripts to manage Exchange 2000 with the reskit utils. Bob "gigi" <anonymous@discussions.microsoft.com> wro...

Outlook 2007 -- removing attachments
Hi. To control the size of my Outlook mailbox, I often save attachments elsewhere and then delete them from the email. I don't remember having had this problem before, but in any case I am now finding that I cannot delete photos or documents that were inserted into, rather than attached to, messages. Can anyone tell me how to do delete them? Thank you. -- hammar2007 To remove attachments or photos that have been embedded into the message body, you'll have to place the message in edit mode first. Open the message via a double click-> button Other Actions-> b...

update worksheet in one file with worksheet in another file
I want to have one worksheet in one of my excel files (file 1) to reflect the contents of a worksheet in another file (file 2) every time it is opened (file 1), that is, everytime it is opened this one tab should reflect the last changes made on the tab in another file, including formating. I suspect this is possible but I don't have a clue how to do it. I have a few questions: Can this be done without VBA? (I'm not even a beginner with VBA!) I did search the web some and found the following that looks interesting: http://techrepublic.com.com/5208-6230-0.html?forumID=101&threadI...

Log files filling disk up
We have an Exchange Server 2003 implementation. It is generating 5MB logfiles every few minutes, and within a few weeks is filling the available disk space. Any advice on hoe these logfiles can be managed would be much appreciated. Thanks Dave Are you doing Exchange-aware full online backups? On Mon, 6 Sep 2004 06:44:41 -0700, "Dave Marshall" <dj_marshall@yahoo.com> wrote: >We have an Exchange Server 2003 implementation. > >It is generating 5MB logfiles every few minutes, and >within a few weeks is filling the available disk space. > >Any advice...

import number data doesn't allow summing
I'm importing a txt file. one of the columns contains numbers. After import, I am unable to sum or perform any number manipulation. I'd appreciate any help Thanks Craig Hi Craig probably the numbers are stored as text format. Try the following: 1. Format the column as number/general (goto 'Format - Cells') 2. Enter a 1 in an empty cell, select this cell and copy this cell (CTRL+C) 3. Select the column with your numbers and goto 'Edit - Paste Special'. Select the action 'Multiply' That should work Frank craig wrote: > I'm importing a txt file. one of...

Protection removed by copying
I have created a workbook with password protected sheets and protected workbook but when I copy the sheets into a new workbook the protection is removed. This kind of defeats the objective of password protection doesn't it?. How can I preserve the protection so that when a user copies a sheet using either Edit/Copy or Ctrl+C the protection is retained or it is possible to disable the copy command? David Hi David If you copy the whole sheet to a new workbook the protection remain But not if you copy only the cells to a other workbook > How can I preserve the protection so that ...

how to remove password pretected excel file
Hi, We use Excel 2003 on Windows XP. We have an user left company with a excel file password protected. My boss want to open it. How can I help my boss open this file? Any help will be appreciated! thanks in advance! Lisa In article <3A1869D6-5D90-47FC-AED7-C0170EB1C159@microsoft.com>, =?Utf-8?B?TGlzYQ==?= <Lisa@discussions.microsoft.com> wrote: >Hi, > >We use Excel 2003 on Windows XP. We have an user left company with a excel >file password protected. My boss want to open it. How can I help my boss open >this file? > >Any help will be appreciated! Se...

Relay operation rejected ASAP!
Dear All, I got this message when i try to send test message. I telnet the port and it response and also use online utility to check if my mail is working and it is. What I could be missing? I even delete all the entry in the Relay Option in the SMTP Virtual Server! The message could not be sent because one of the recipients was rejected by the server. The rejected e-mail address was 'administrator@tcl.com.ph'. Subject 'test using the mailserver on mailserver', Account: 'mailserver', Server: 'mailserver', Protocol: SMTP, Server Response: '554 &...

file size question
i have a workshbook that uses vlookups to a separate workbook. the file jumped from 29kb to 2,068kb. is that normal? or are there things i can do to bring that file size back down? Hi James, I had the same with one of my files. It appeared that i had applied formatting and formulas to whole colums and rows, that seems to take a lot of memory. So i tried to apply the formatting and formulas to only the cells for which it was neccesary. That worked for my files. HTH Fred "James" <james@guidant.com> schreef in bericht news:e$rWN2xTEHA.1284@TK2MSFTNGP10.phx.gbl... > i...

Don't allow a space in a cell...how to prevent?
One of my students asked an interesting question yesterday in Excel. We were working on IF statements and if a cell had a student's name in it, the IF statement proceeded to do the FALSE Result, if not, it did the TRUE Result. =if(A1="","student missed class","student attended class") I explained that if a student hit the space bar and entered "a space", this space would be considered something and the IF statement would produce the FALSE Result of "student attended class". Student's question (and mine): Is there a way to prevent ...