Instead of using the built-in database tools, our database team would like to know what script is used so they can do the maintenance on our system.

Any help would be much appreciated.

@echo off
set LOGFILE=c:\logs\WhatsUp_DB-Maint.log
echo ***************************************************************************** > %LOGFILE%
echo Start date: %date%   time: %time% >> %LOGFILE%
echo ***************************************************************************** >> %LOGFILE%
echo osql -E -D WhatsUp -Q "DBCC SHRINKDATABASE (WhatsUp)" >> %LOGFILE%
osql -E -D WhatsUp -Q "DBCC SHRINKDATABASE (WhatsUp)" >> %LOGFILE%

echo ***************************************************************************** >> %LOGFILE%
echo osql -E -D WhatsUp -Q "EXEC sp_MsForEachTable 'DBCC DBREINDEX (''?'', '''', 0)'" >> %LOGFILE%
osql -E -D WhatsUp -Q "EXEC sp_MsForEachTable 'DBCC DBREINDEX (''?'', '''', 0)'" >> %LOGFILE%

echo ***************************************************************************** >> %LOGFILE%
echo osql -E -D WhatsUp -Q "EXEC sp_createstats" >> %LOGFILE%
osql -E -D WhatsUp -Q "EXEC sp_createstats" >> %LOGFILE%

echo ***************************************************************************** >> %LOGFILE%
echo osql -E -D WhatsUp -Q "EXEC sp_updatestats" >> %LOGFILE%
osql -E -D WhatsUp -Q "EXEC sp_updatestats" >> %LOGFILE%

echo ***************************************************************************** >> %LOGFILE%
echo osql -E -D WhatsUp -Q "EXEC sp_MsForEachTable 'sp_recompile ''?'''" >> %LOGFILE%
osql -E -D WhatsUp -Q "EXEC sp_MsForEachTable 'sp_recompile ''?'''" >> %LOGFILE%

echo ***************************************************************************** >> %LOGFILE%
echo osql -E -D WhatsUp -Q "DBCC UPDATEUSAGE ('WhatsUp')" >> %LOGFILE%
osql -E -D WhatsUp -Q "DBCC UPDATEUSAGE ('WhatsUp')" >> %LOGFILE%

echo ***************************************************************************** >> %LOGFILE%
echo osql -E -D WhatsUp -Q "EXEC sp_cycle_errorlog" >> %LOGFILE%
osql -E -D WhatsUp -Q "EXEC sp_cycle_errorlog" >> %LOGFILE%

echo ***************************************************************************** >> %LOGFILE%
echo osql -E -D WhatsUp -Q "DBCC SHRINKDATABASE (WhatsUp)" >> %LOGFILE%
osql -E -D WhatsUp -Q "DBCC SHRINKDATABASE (WhatsUp)" >> %LOGFILE%

echo ***************************************************************************** >> %LOGFILE%
Echo Completed database maintenance...starting backup >> %LOGFILE%
echo ***************************************************************************** >> %LOGFILE%

OSQL -E -n -D WhatsUp -Q "BACKUP DATABASE WhatsUp TO DISK = 'c:\whatsup backup\WhatsUpDB.dat' WITH INIT" >> %LOGFILE%
echo ***************************************************************************** >> %LOGFILE%
Echo Completed backup at: %time% >> %LOGFILE%
echo ***************************************************************************** >> %LOGFILE%