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

shrinking database Expand / Collapse
Author
Message
Posted Tuesday, January 1, 2013 1:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 4, 2014 1:08 AM
Points: 3, Visits: 77
hi all,


i want to know that ,can we shrink the database at the time of working on that database. if it does is there any data loss or safe??
please give answer to this question asap
Post #1401560
Posted Tuesday, January 1, 2013 1:17 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: Yesterday @ 3:43 PM
Points: 43,047, Visits: 36,206
Safe. Not usually a good idea, but safe.

If you decide to shrink, you need to rebuild all your indexes afterwards. Don't shrink as small as possible, shrink to a sensible size (leaving some free space for normal operation). Don't schedule shrinks.



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 #1401561
Posted Wednesday, January 2, 2013 1:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:26 AM
Points: 2,840, Visits: 3,963
lathish2kumar (1/1/2013)
please give answer to this question asap
it seems that you went straightaway to apply this . to gain some space. and if thats the case then you might be doing this in future too .So i will suggest you to read some link as http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/13/629059.aspx


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1401686
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse