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:

 

BACKUP LOG ‘MyDatabase’ WITH TRUNCATE_ONLY

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 :

 1)    BACKUP LOG [DBNAME] TO DISK='NUL'

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 (http://www.sqlserver-dba.com)

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.