HELP: Transaction Log Backup Files

Hello world,
I am having some diffulty finding the method to truncate my MSSQL
transaction logs files.
I am successful backing up the system and user tables and the logs ( using
a maintianace wizard, But there isnt an option for logfile truncate'
1) Do Maintance Wizards truncate the log files automatically?
2) WHERE can i find this option?
RussTruncating the transaction log from Query Analyzer:
BACKUP LOG database_name WITH NO_LOG or TRUNCATE_ONLY
This statement will never backup log actualy but truncate inactive portion of log file.
It's better idea to let the SQL Server do all that through maintenance plans and regular log backup bacause after every log backup SQL will truncate inactive portion of log file.
Also you should check db recovery options!
More info BOL - "Truncating the Transaction Log"
hope it helps|||Why would you want to truncate the log file regularly? It only cost performance etc to truncate it
and then having it autogrow back...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Stephen Driscoll" <info@.fnc.co.uk> wrote in message news:%23bjBigKwDHA.2460@.TK2MSFTNGP10.phx.gbl...
> Hello world,
> I am having some diffulty finding the method to truncate my MSSQL
> transaction logs files.
> I am successful backing up the system and user tables and the logs ( using
> a maintianace wizard, But there isnt an option for logfile truncate'
> 1) Do Maintance Wizards truncate the log files automatically?
> 2) WHERE can i find this option?
> Russ
>