InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 06:03:03 GMT20http://www.sqlservercentral.com/Forums/Topic1401560-338-1.aspx[quote][b]lathish2kumar (1/1/2013)[/b][hr]please give answer to this question asap[/quote] 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 [url]http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/13/629059.aspx[/url]Wed, 02 Jan 2013 01:49:20 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1401560-338-1.aspxSafe. 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.Tue, 01 Jan 2013 01:17:13 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1401560-338-1.aspxhi 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 asapTue, 01 Jan 2013 01:10:47 GMTlathish2kumar