• nitin.doshi (11/20/2012)


    In one of our servers tempdb is grown to 75 gb. If we check properties of tempdb it is showing 73 gb free, but when we try to shrink tempdb it is giving below given error.... Has anybody faced similar issue and resolved..

    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.

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    what is log file size of tempdb out of 75 GB

    -----------------------------------------------------------------------------
    संकेत कोकणे