Wednesday, October 21, 2009

'TRUNCATE_ONLY' is not a recognized BACKUP option

  • when i use backup query of my friend in sql server 2008 express (from old sql server 2005 can use this query) can't use this query and return error follow this message
Msg 155, Level 15, State 1, Procedure backup_store_name, Line 55
'TRUNCATE_ONLY' is not a recognized BACKUP option.

Solved

  • i comment this code in query for solved this error message
--BACKUP LOG dbname WITH NO_LOG
--BACKUP LOG dbname WITH TRUNCATE_ONLY
--DBCC shrinkdatabase(dbname, TRUNCATEONLY )

Reference

No comments:

Post a Comment