Post reply

DBCC SHRINKDATABASE TRUNCATEONLY

  • November 20, 2011 at 1:51 am

    #252115

    Hi,

    I need help in considering DBCC SHRINKDATABASE TRUNCATEONLY. I have read a lot of articles about moving away from this option however, I am running out of options in freeing up space to the OS.

    I only inherited this database. It has four filegroups including log and is very large having approx. 600GB when creating a full backup.

    I'm currently archiving and thus removing a large portion of the tables. But deleting does not free up the space to the OS. What would be the steps that I take to free up space?

    Thank you.

    Regards

  • November 20, 2011 at 2:20 am

    #1410381

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1208895-146-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

You must be logged in to reply to this topic. Login to reply