January 1, 2013 at 1:10 am
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
January 1, 2013 at 1:17 am
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 2, 2013 at 1:49 am
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;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply