Microsoft has completely removed the BACKUP LOG WITH TRUNCATE_ONLY capability completely from SQL Server 2008. If you try to attempt to execute the following command:
BACKUP LOG AdventureWorks WITH TRUNCATE_ONLY
This is the result:
'TRUNCATE_ONLY' IS not a recognized BACKUP OPTION.
To circumvent this error in a DEVELOPMENT environment (not Production), use the following commands:
USE AdventureWorks GO ALTER DATABASE AdventureWorks SET RECOVERY SIMPLE DBCC SHRINKFILE(N'AdventureWorks_log', 1) ALTER DATABASE AdventureWorks SET RECOVERY FULL GO
One should never execute the above commands in a Production environment unless you wish to lose all of your prior transaction log backups and the ability to restore to a given point in time based on those backups.
Reference
- DBCC SHRINKFILE (Technet)
1 Comments.