Hi, There are pros and cons of doing this activity, unless required it is not recommended to shrink and why is that so please refer Tibor Karaszi's article here http://www.karaszi.com/SQLServer/info_dont_shrink.asp Hope this article will give you more insight on it. Regards

Hi, apart from what has been suggested by Satya and Luis I would recommend reading below articles http://support.microsoft.com/default.aspx/kb/110139 & http://support.microsoft.com/default.aspx/kb/317375 -- Why T-Log has been filled up http://support.microsoft.com/kb/873235 -- Shrinking Database...