REM shuts down sql server, copies sql data and  SCANX pictures from PHOTO SERVER to external USB HD

REM EMAILS results of backup using bmail (shareware) by calling another batchfile

@echo off
REM ERRORLEVEL added August 2008
REM DOES VIPERNEW\MSDE be "VIPERNEW\MSDE\*.*"
echo **USBBackup.bat** >D:\BATCH\USBBackup.txt

NET STOP Mssql$Viper /y
Echo SQL Service Stopped and VIPER SQL **USB-BACKUP** (not \\Terastation) started at %Date% %Time% >> D:\BATCH\USBBackup.txt
REM echo. >>D:\BATCH\USBBackup.txt

REM \MSDE USB BACKUP
XCOPY D:\VIPERNEW\MSDE\*.* E:\VIPERNEW\MSDE /c/s/i/y/f
if %errorlevel% EQU 0 echo Successful BACKUP of ** \MSDE DIRECTORY** to USB DRIVE >> D:\BATCH\USBBackup.txt
if %errorlevel% EQU 4 goto ERROR

net start Mssql$Viper
echo. >>D:\BATCH\USBBackup.txt
ECHO **SQL SERVICE** RE-STARTED at %Date% %TIME% >>D:\BATCH\USBBackup.txt

ECHO. >>D:\BATCH\USBBackup.txt
ECHO Begin ENTIRE \VIPERNEW Directory BACKUP to USB Drive >>D:\BATCH\USBBackup.txt
XCOPY D:\VIPERNEW E:\VIPERNEW /c/s/i/y/f/d
if %errorlevel% EQU 0 echo Successful VIPERNEW\ Backup USB DRIVE >> D:\BATCH\USBBackup.txt
if %errorlevel% EQU 4 echo ERROR: VIPERNEW\ USB Backup FAILED (Missing USB Drive?) >> D:\BATCH\USBBackup.txt

REM echo. >>D:\BATCH\USBBackup.txt

REM ECHO Begin ENTIRE \VIPERNEW-H Directory BACKUP to USB Drive >>D:\BATCH\USBBackup.txt
XCOPY H:\VIPERNEW-H E:\VIPERNEW /c/s/i/y/f/d
if %errorlevel% EQU 0 echo Successful VIPERNEW-H\ Backup USB DRIVE >> D:\BATCH\USBBackup.txt
if %errorlevel% EQU 4 echo ERROR: VIPERNEW-H\ USB Backup FAILED (Missing USB Drive?) >> D:\BATCH\USBBackup.txt
ECHO. >>D:\BATCH\USBBackup.txt
ECHO Both \VIPER Directories BACKUP completed at %Date% %TIME% >>D:\BATCH\USBBackup.txt

CALL "D:\batch\USBbmailViper.bat"
EXIT

:ERROR
ECHO ERROR: USB \MSDE Backup FAILED - INVALID DRIVE (Missing USB Drive?) >> D:\BATCH\USBBackup.txt
net start Mssql$Viper
echo. >>D:\BATCH\USBBackup.txt
ECHO SQL SERVICE RE-STARTED at %Date% %TIME% >>D:\BATCH\USBBackup.txt
CALL "D:\batch\USBbmailViper.bat"