ADSM-L

Re: Need help on how to Truncate MS SQL

2002-09-09 11:19:14
Subject: Re: Need help on how to Truncate MS SQL
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 9 Sep 2002 11:15:47 -0400
> 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.

<Prev in Thread] Current Thread [Next in Thread>