anthony.green (2/19/2013)

---

SQLCrazyCertified (2/19/2013)

---

mwagh (2/19/2013)

---

Thanks!! works in my case as i have a lot initially allocated space which was never touched.

Hi, sorry, I was not aware of this, anyway, with truncate only option only available for sql 2005 right? because I know they took away this option for 2008 and above. Just curious which version you are using.

SueTons.

TRUNCATE ONLY been removed from the BACKUP LOG command, but not from DBCC SHRINKFILE