Reg:Shrink Database not happen

  • vs.satheesh


    Points: 2215

    Dear All,


    In My production environment , every six month cycle we are replace the database server.whenever replace the database we are truncate all the unwanted transaction data. My problem is after truncate the data i try to shrink the database. But not reduce the MDF file size.i tried all the possibilities like

    1. Change the database recover mode in simple i tried , that time also not working
    2. Index rebuild all the tables
    3. mdf and ldf separately tried
    4. backup file got reduced but mdf file not reduced.

    please give solution for above this problem.



  • Andrey

    SSChasing Mays

    Points: 617


    1. Are there any LOB columns (text, image, varchar(max), etc) in the tables where you truncate (delete?) the data?
    2. do you see and how do you check that free space exists in the database?
    3. provide the output of the following:
       select @@version?





  • Erland Sommarskog


    Points: 23770

    The solution is simple. Don't shrink. There is no point in shrinking if you are going to fill up the space again. Also, shrinking the data files introduces a ton of fragmentation.

    You can also read SQL Server MVP Tibor Karaszi's article on the topic:


    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP,[/font]

  • Andrey

    SSChasing Mays

    Points: 617

    vs.satheesh wrote:

    please give solution for above this problem.    

    also, check this out:

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

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