BACKUP LOG my_DB_name WITH NO_LOG

Dave

-----Original Message-----
From: Shawn Smith [mailto:[Email Address Removed] Wednesday, August 28, 2002 8:40 AM
To: LazyDBA.com Discussion
Subject: truncate the transaction log


What is the syntax to truncate the transaction log to a database?

I thought it was truncate transaction with no_log....that appears not to be
working.

Shawn Smith
Database Administrator
Fort Worth Star-Telegram
817-390-7094
817-291-5240 cell
817-667-2757 pager
[Email Address Removed]MS Sql Server LazyDBA home page