Post reply

Shrink Db

  • July 9, 2009 at 6:38 am

    #75500

    Dear All,

    When we shrinking the database , that will reduce the database Size

    But I need to know, Actually what happen in while shrinking,

    Is there is any data loss are tell me What u have a Ideas About?

  • July 9, 2009 at 6:52 am

    #1022319

    Saravanan_tvr (7/9/2009)

    Dear All,

    When we shrinking the database , that will reduce the database Size

    But I need to know, Actually what happen in while shrinking,

    Is there is any data loss are tell me What u have a Ideas About?

    Shrinking wont let you to lose any data. however there are many side-effects of shrinking. The most important is fragmentation. It generates high level of fragmentation in your database which will result in poor performance. Secondly, since your database is set to grow, it'll seek for free space from the OS which is again a time consuming process and will slow down the system.

    Why do you need to shrink the database?


    Pradeep Singh

  • August 5, 2014 at 4:19 am

    #1735070

    Don't shrink. This is bad practise

  • August 5, 2014 at 4:20 am

    #1735072

    Please note: 5 year old thread.

    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 4 posts - 1 through 3 (of 3 total)

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