Appaji Patil
asked on
Shrinking Temp DB
When trying to Shrink TempDB on one of the Production DB server getting below error msg.
Could not cleanup worktable IAM chains to allow shrink or remove file operation. Please try again when tempdb is idle.
Could not cleanup worktable IAM chains to allow shrink or remove file operation. Please try again when tempdb is idle.
As mentioned in the error message, some Index Allocation Map(IAM) process is using your tempdb pages which SQL Server can't move as part of your tempdb Shrink file request. So, you have 2 options, either to wait for those process to complete and perform Shrink tempdb during idle hours as suggested above or Restart SQL Server service to get the file size shrunk out..
ASKER
Its been from Long time I am getting this msg.
Is there any alternative way other Restart of SQL services
Is there any alternative way other Restart of SQL services
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Initiating auto close as we haven't heard back from Author and solution was proposed..