Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Help, shrink file not releasing space

    SQLRNNR (8/11/2014)

    Are you getting any errors?

    Have you checked for any blocking?

    Or is it just that the shrink is running a really long time and never ending?

    No, GUI showed the sql...

    August 11, 2014 at 10:04 pm

    #1737096

  • RE: Help, shrink file not releasing space

    SQLisAwE5OmE (8/11/2014)

    If there is cluster index on the purge table, recreate the cluster index and then shrink the database, that should release the space to OS.

    Or can we perform...

    August 11, 2014 at 9:59 pm

    #1737095

  • RE: Help, shrink file not releasing space

    Gazareth (8/11/2014)

    Can you run it without the WITH NO_INFOMSGS & see what the output says?

    Also add print ( @sql ) directly before/after exec ( @sql ) so you can see...

    August 11, 2014 at 9:58 pm

    #1737094

Viewing 3 posts - 1 through 3 (of 3 total)