Post reply

Unable to Shrink Database files

  • January 14, 2011 at 12:47 am

    #1273430

    Shrink doesn't compress the database. It just releases unused space to the file system. It also will not change the size of a backup, as backups only contain the data in the database, not the free space in the database.

    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

  • January 15, 2011 at 8:57 am

    #1273914

    If all you need to do is shrink the backup file, look into the backup utilites that provide compression - or use a compression tool on the backup file (e.g. winziip, rar, 7zip, etc...).

    Redgate has a couple of tools available, as well as Quest and Idera. You should review them and determine which one has the best features for your organization.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

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

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