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?