Could not cleanup worktable IAM chains to allow shrink or remove file operation. Please try again when tempdb is idle
in [Programming SQL]
|
From: gv on 25 Jun 2010 09:29 Hi all, I'm getting this message when trying to clear tempdb DBCC SHRINKDATABASE (tempdb, 10) WITH NO_INFOMSGS 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
From: gv on 25 Jun 2010 10:05 this did it. use tempdb go dbcc shrinkfile (tempdev, 5000) go thanks, gv "gv" <viator.gerry(a)gmail.com> wrote in message news:%23BZ7wpGFLHA.5736(a)TK2MSFTNGP02.phx.gbl... Hi all, I'm getting this message when trying to clear tempdb DBCC SHRINKDATABASE (tempdb, 10) WITH NO_INFOMSGS 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
|
Pages: 1 Prev: Run query on multiple databases Next: Find distinct records of the last order from a customer |