Truncate_only deprecated in SQL2008

Question

The following statement

BACKUP LOG [AMS_Prod_log] WITH TRUNCATE_ONLY

works fine in SQL Server 2005 but it doesn't with 2008. It seems truncate_only is deprecated in 2008. Could you please let me know how to achieve this in 2008? What care needs to be taken like backup... etc?

Answer 1

Here Is article by Paul Randall concerned with this problem.

Answer 2

This is the list of features depreciated in SQL 2005 i.e. they will not be available in SQL 2008.

http://msdn.microsoft.com/en-us/library/ms143729%28SQL.90%29.aspx

Your alternative is provided in the link.