Have you tried BACKUP LOG {database_name} WITH TRUNCATE_ONLY?
>Hi All:
> I am still not sure on how to truncate my transactions log file.
>If I was to issue these two commands from the sql server, would my transactions log be truncated? If not, what do I need to do? Help!!!!
>(1). Datawarehouse_Data.Truncate( )
>(2). Dbcc Shrinkfile(Datawarehouse_Data,Truncateonly)
>Thanks
>MA
- Jayesh