Shrink Database

  • I have a database that is 58.9gb, of that 32.4 is used and 26.5 is free.

    after I shrink the database how do I change the 58.9gb to be 40gb and have it maintain that size?

  • DO NOT SHRINK databases. This messes with your indexes and increases fragmentation.

    You need to have free space in your database. As people add data or change it, there should be space for the data to be added to the database. This is separate from the log. If this is a static database, then there won't be any growth.

    The log will grow as you add, delete, or change data as it contains all of the changes made. You should have log backups to manage this.

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

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