SQL03160: NO_LOG and TRUNCATE_ONLY options were removed in SQL Server 2008.

Question

the error is on this line:

BACKUP LOG PROLinkCenter WITH TRUNCATE_ONLY

Answer 1

Hi,

The error message you got is telling what happened: NO_LOG and TRUNCATE_ONLY options were on longer supported in SQL Server 2008.

Please also take a look at these 2 cases for more information:
http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/47e18f6d-d1b0-427f-81f4-b557c9a1e28f
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/d64dc18b-52f8-4c8b-8be2-1a837988776e/

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us