Hello everyone..

I have learned in a blog that the below command on execution empties the log without actually backing it up. And i am confused on reading that.

"BACKUP LOG DB_NAME WITH TRUNCATE_ONLY"

So i request someone here for clarification of what's the actual functionality of the above co

Basically you are flushing the log file , there won't be any pointers to any transactions hence you can't do a point in time recovery. Its basically fooling the sql server and breaking the LSN's.

Its taking a backup to null device. This feature is deprecated in 2008 onwards.

If you want to do this, change the recovery model to simple and shrink the log file.

-Prashanth

• Edited by Prashanth Jayaram 15 hours 6 minutes ago

I highly recommend not to use this ever!

Check the link I posted in your preview question. It is all explain there:
http://www.brentozar.com/archive/2009/08/backup-log-with-truncate-only-in-sql-server-2008/

* As mentioned in SQL 2008 or 2008r2 this was removed and you cant use it any way :-)