Post reply

What are the technique to reclaim space on SQL 2005?

  • October 6, 2011 at 8:07 am

    #244161

    Hi,

    Am new to MSSQL 2005, i've read some article about shrinking datafile which result as follow:

    Shrink datafile: then DB Size decrease but loads of fragmentation

    Fragmentation: then Rebuild Indexes

    Rebuild Indexes: then DB Size increased

    Ex:

    Original DB Size: 9M

    Truncate table + Shrink: 5M

    Fragementation increase

    Rebuild index: DB Size 21M

    Are there any other techniques about how to reclaim space if its required?

  • October 6, 2011 at 8:18 am

    #1391219

    You should leave your database to a size you think is sufficient to grow for may be a year or 6 months or so.

    Having said that, If you have got no option but to reclaim space used by a data/log file, you will need to find out free space within the data/log file and then shrink it.This will release unused space within the file to the operating system.

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

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