Combined Dump and Maintenance Batch Process.

Here is the database dump script called by this driver.

@echo off
  cls

  title=Database Maintenance

rem Do some basic stuff to validate the command line
rem verify that two arguments are given
  if "%2" == ""  goto :badcall

  set maintenance_status=go


rem Dump each database

  if %maintenance_status%==stop goto :end
  echo dumping database master...
  call d:\dbmaint\dbdump sa %1 %2 master
  echo:

  if %maintenance_status%==stop goto :end
  echo dumping database pubs...
  call d:\dbmaint\dbdump sa %1 %2 pubs
  echo:
  
  if %maintenance_status%==stop goto :end
  echo dumping database testdb...
  call d:\dbmaint\dbdump sa %1 %2 testdb
  echo:

rem enter a call for each database to be maintained on the SQL Server
  if %maintenance_status%==stop goto :end
  call d:\dbmaint\maint sa %1 %2 master
  call d:\dbmaint\maint sa %1 %2 pubs
  call d:\dbmaint\maint sa %1 %2 testdb

  echo: 
  echo Maintenance complete
  goto :end

:badcall
  echo:
  echo  usage:  dbmaint [Password] [Server]  
  echo: 
  echo          where 
  echo            [Password] is the sa password  
  echo            [Server] is the SQL Server to be maintained
  echo:               

:end