Hi All, How do I have to shrink the Transaction log file of the user database in SQL SERVER 2008? In the earlier version of the sqlserver we can do the same by using the below command Backup log <database name> with truncate_only DBCC shrinkfile(<Log_filename>, <size>) When I run the above commands I get the below error message 'truncate_only' is not a recognized BACKUP option. I don't want to backup the database. I tried to change the Recovery model of the database from full to Simple, still It didn't help me. Can someone guide me how to Shrink the transactional log file to the desired size in sql server 2008. Thanks in Advance.