Hello Ted,

It was pointed out to me that I *should* be performing a weekly maintenance
of Squish EchoMail databases and the following was what I've come up with:

(Join the ellipses and delete the ......)

=== Cut Begin: SQM.BAT ===
{at}echo off
break on
on break goto end
goto begin

:check
echo  Checking:  %{at}name[%%a] | tee /a E:\Fd\Sq\SQMAINT.LOG
E:\Fd\Sq\sqinfo %{at}name[%%a] -e >> E:\Fd\Sq\SQMAINT.LOG
  if errorlevel 1 gosub fix
E:\Fd\Sq\sqpack %{at}name[%%a] | tee /a E:\Fd\Sq\SQMAINT.LOG
  return

  :fix
  echo    Errors found in:  %{at}name[%%a] | tee /a E:\Fd\Sq\SQMAINT.LOG
  E:\Fd\Sq\sqfix32 %{at}name[%%a]
  ::  SQFIX32 can rebuild message areas of almost any size.
  echo      %{at}name[%%a] FIXED! | tee /a E:\Fd\Sq\SQMAINT.LOG
  ::  I would like to know if the following lines would delete the old data
  ::  files (.XXD) and the old index files (.XXI)...
  ::
  ::  for %%x in (E:\Fd\Mail\*.xx? E:\Fd\Mail\Band\*.xx? E:\Fd\Mail\...
  ::      ...Rust\*.xx?) do del /q %%x
  ::  echo      %{at}name[%%x] REMOVED! | tee /a E:\Fd\Sq\SQMAINT.LOG
  return

:begin
pushd
cdd E:\Fd\Mail
::  add drive and directory names for new Squish database files as required)
for %%a in (E:\Fd\Mail\*.sqd E:\Fd\Mail\Band\*.sqd E:\Fd\Mail\...
    ...Rust\*.sqd) do gosub check

:end
cd\
popd
=== Cut End:   SQM.BAT ===

The above batch file "appears" to perform the tasks...  :-))

    G'Day ... Gerald

--- GoldED/386 2.50 UNREG