@echo off
SET serverName=wonka_b
SET dataDrive=E:
SET serverTransName=%serverName%_trans
SET backupServer=\\share.wellsource.com
SET backupLocation=%backupServer%\SQLBackups\%serverName%
SET zLoc=C:\Program Files\winrar\rar.exe

echo -------------------------------------------------------- >> c:\backuplog.txt
echo %date% %time% starting backup run. >> c:\backuplog.txt
echo %date% %time% mounting network share >> c:\backuplog.txt
net use s: \\share.wellsource.com\SQLBackups\%serverName% /user:wellsource\rprague Apprentice1!

IF NOT EXIST S:\mounttest (
  ECHO Backup Location does not exist!: %backupLocation% >> c:\backuplog.txt
  GOTO Error
)
echo %date% %time% %backupServer%\%serverName% network share mounted >> c:\backuplog.txt

IF NOT EXIST "%zLoc%" (
  ECHO 7zip not found! >> c:\backuplog.txt
  GOTO Error
)

echo %date% %time% compressing/deleting transaction logs >> c:\backuplog.txt
for /R "%dataDrive%\%serverTransName%" %%A in (*.trn) do "%zLoc%" a "%%A.rar" "%%A"
IF NOT ERRORLEVEL 0 (
  ECHO ERROR in transaction compression! >> C:\backuplog.txt
  GOTO Error
)
forfiles -p "%dataDrive%\%serverTransName%" /S /M *.trn -c "cmd /c del @path"
forfiles -p "%dataDrive%\%serverTransName%" /S /M *.trn.rar /D -1 -c "cmd /c del @path"

echo %date% %time% compressing .dbk files >> c:\backuplog.txt
for /R "%dataDrive%\%serverName%" %%A in (*.dbk) do "%zLoc%" a "%%A.rar" "%%A"
IF NOT ERRORLEVEL 0 (
  ECHO ERROR in diff backup compression! >> C:\backuplog.txt
  GOTO Error
)
forfiles -p "%dataDrive%\%serverName%" /S /M *.dbk -c "cmd /c del @path"

echo %date% %time% copying .dbk files to %backupLocation% >> c:\backuplog.txt
forfiles -p "%dataDrive%\%serverName%" /S /M *.dbk.rar -c "cmd /c copy @path %backupLocation%"
forfiles -p "%dataDrive%\%serverName%" /S /M *.dbk.rar -c "cmd /c del @path"

echo %date% %time% compressing .fbk files >> c:\backuplog.txt
for /R "%dataDrive%\%serverName%" %%A in (*.fbk) do "%zLoc%" a "%%A.rar" "%%A"
IF NOT ERRORLEVEL 0 (
  ECHO ERROR in full backup compression! >> C:\backuplog.txt
  GOTO Error
)
forfiles -p "%dataDrive%\%serverName%" /S /M *.fbk -c "cmd /c del @path"
echo %date% %time% copying .fbk files to %backupLocation% >> c:\backuplog.txt
forfiles -p "%dataDrive%\%serverName%" /S /M *.fbk.rar -c "cmd /c copy @path %backupLocation%"
forfiles -p "%dataDrive%\%serverName%" /S /M *.fbk.rar -c "cmd /c del @path"

:End
echo %date% %time% ending backup run normally. >> c:\backuplog.txt
net use s: /DELETE
exit 0

:Error
echo %date% %time% ERROR DETECTED!  Ending Backup Run! >> c:\backuplog.txt
net use s: /DELETE
exit 1