Shrink Db

  • 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?

  • 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

  • Don't shrink. This is bad practise

  • 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