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:hoobler AT US.IBM DOT COM]
Sent: Monday, September 09, 2002 5:16 PM
To: ADSM-L AT VM.MARIST DOT EDU
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
hoobler AT us.ibm DOT com

- 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