Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

TRUNCATE_ONLY is not a recognized BACKUP option

Executing the code below in SQL Server 2008 will throw an error message:



Msg 155, Level 15, State 1, Line 44
'TRUNCATE_ONLY' is not a recognized BACKUP option.

It was deprecated in SQL Server 2008.

 Some options for SQL Server 2008 are :


This will break the  transaction log chain. Therefore a Full backup is required after the command.

2)    Switch to Simple Recovery and then switch back to Full Recovery. This will required a Full backup to restart a new  transaction log chain

 3)  DBCC SHRINKFILE(Test_Log)    . This option causes fragmentation , but does the job when it comes to reclaiming space.   You might find it doesn’t shrink – in that case check for open transactions.

4) Take regular Transaction Log backups while maintaining a small log file size

 The choice will depend on the circumstances.

Author: Jack Vamvas (


No comments.

Leave a Comment

Please register or log in to leave a comment.