InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 11:21:04 GMT20http://www.sqlservercentral.com/Forums/Topic1357151-1292-1.aspxJitendra,You might want to review this URL: http://sqlserverpedia.com/wiki/Shrinking_DatabasesIt provides a good oversight to concerns when shrinking your database. Hope this helps.Tue, 11 Sep 2012 13:16:06 GMTjralston88http://www.sqlservercentral.com/Forums/Topic1357151-1292-1.aspxYou'll find all the required info in Books Online [url=http://technet.microsoft.com/en-us/library/ms189493.aspx][u][b]here[/b][/u][/url] and [url=http://technet.microsoft.com/en-us/library/ms190488][u][b]here[/b][/u][/url]Tue, 11 Sep 2012 01:34:06 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1357151-1292-1.aspxIs shrinking of data file, or log file can affect performance ?Tue, 11 Sep 2012 01:09:29 GMTjitendra.padhiyarhttp://www.sqlservercentral.com/Forums/Topic1357151-1292-1.aspxHello Masters,How the shrinking works? What happened when shrinking log file or DB file ? on my test db (whose actual size was 3400 MB), I went to shrink task and shrink log file and now db size is 610 MB!!I shrink log file, than how db file shirnked ? Is it affecting any production? In shrink action, second option is "Shrink File to" and than we have to feed some numeric value in MB, whats that factor is ? how that count is used to shrink a file?Please if anyone can explain me it will be helpful for me to work on production.thanks in advance.JitendraTue, 11 Sep 2012 00:13:08 GMTjitendra.padhiyar