jfoster (3/18/2009)

---

Krishna,

I thought I'd post another alternative which I didn't see in your article. I've used this in the past, with good results. This method allows me to run it on a live database without causing issues. At the same time, I have had issues where the log file never seemed to decrease after a shrinkdatabase...this has had 100% good results. Of course, the disclaimer would be that you are definitely purging the log file(s), so there is no going back if you didn't back them up.

USE [AdventureWorks]

DUMP TRAN [AdventureWorks] WITH NO_LOG

GO

DBCC SHRINKDATABASE ('AdventureWorks', 1)