Yes , we need to now how to do this with a command so that we can run it on a daily backup
-----Original Message----- From: Del Hoobler [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 5:16 PM To: [EMAIL PROTECTED] Subject: Re: Need help on how to Truncate MS SQL > I need help on a command on how to truncate a database for MS SQL > We are running SQL 6.5 and SQL 7 on a NT platform > agents I have is v1.1 and v2.2 Hugo, Do you mean how do you truncate the log? After a successful "full" or "log" backup, the SQL database transaction log is truncated... ...unless you specify the option to not truncate the log. Thanks, Del ---------------------------------------------------- Del Hoobler IBM Corporation [EMAIL PROTECTED] - Never cut what can be untied. - Commit yourself to constant improvement. --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.384 / Virus Database: 216 - Release Date: 8/21/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.384 / Virus Database: 216 - Release Date: 8/21/2002
