Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Shrink Db Expand / Collapse
Author
Message
Posted Thursday, July 9, 2009 6:38 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 280, Visits: 1,203
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?


Many Thanks!
S.saravanan
“I am a slow walker, but I never walk backwards-
Abraham Lincoln”
Post #750151
Posted Thursday, July 9, 2009 6:52 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, July 6, 2014 3:07 PM
Points: 2,242, Visits: 3,643
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
Post #750170
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse