I believe the option you should use is "/LOGPRUNE:60". Where 60 is the number of
days you want to keep in your log. This option is the one you shuold specify in
the batch scripts that will be launched via a schedule and which would do the
backup with the "SQLDSMC" command.

Hope this helps,

Michel Engels





Maria Ragan <mragan AT BCO DOT COM> on 08/29/2000 07:03:42 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: Michel Engels/BE/Devoteam)

Subject:  SQLSCHED.LOG Pruning



Can anyone tell me how to prune the connect agent logs?  I have
SCHEDLOGRetention=14 in the dsm.opt file, but the sqlsched.log keeps
growing.

Thanks,

Maria

Maria Ragan
Mid Range Systems
Bear Creek Corporation