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: 2 days ago @ 4:10 AM
Points: 280, Visits: 1,206
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: Friday, August 1, 2014 1:26 PM
Points: 2,242, Visits: 3,645
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
Posted Tuesday, August 5, 2014 4:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 8:08 AM
Points: 3, Visits: 58
Don't shrink. This is bad practise
Post #1599556
Posted Tuesday, August 5, 2014 4:20 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:51 PM
Points: 42,756, Visits: 35,850
Please note: 5 year old thread.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1599558
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse