@echo off

:Update 03-07-2013 (PG)

if exist D:\MRCDBBACKUP.txt del /q D:\MRCDBBACKUP.txt

blat -install smtp.mrcuk.mr-carpet.co.uk mrcbackups@mr-carpet.co.uk


if exist C:\MrC\Servers\ServerTasks\BackupMrC_DB_toSU3200.txt del C:\MrC\Servers\ServerTasks\BackupMrC_DB_toSU3200.txt
:Begin
: Extract the date and apply it to variables.
for /F "tokens=1-4 delims=/ " %%i in ('date /t') do (
    set DayOfWeek=%%i
    set Month=%%j
    set Year=%%k
)


robocopy /e /z /r:3 /w:2 D:\Database D:\Database_%DayOfWeek%-%Month%-%Year%

zip -r -9 -q D:\MrCDB_%DayOfWeek%-%Month%-%Year%.zip D:\Database_%DayOfWeek%-%Month%-%Year%\*.*

echo MRC Daily DB Backup Complete on %DayOfWeek%-%Month%-%Year% (time as of email)>>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo Backup is of 'D:\Database' on %COMPUTERNAME% >>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo The backup is located here: \\SU3200\MrCDatabaseBackups$\MrCDB_%DayOfWeek%-%Month%-%Year%.zip >>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo The DB backup can be retrieved remotely here: ftp://217.40.222.185/dbbackup/MrCDB_%DayOfWeek%-%Month%-%Year%.zip >>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo Note: This is a scheduled daily backup>>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo Regards,>>D:\MRCDBBACKUP.txt
echo Mr Carpet Backups>>D:\MRCDBBACKUP.txt


cls
echo Mapping a drive to the destination folder...
echo.
echo.
net use t: \\SU3200\MrCDatabaseBackups$
echo.
echo.


copy /V /Y D:\MrCDB_%DayOfWeek%-%Month%-%Year%.zip T:\

echo.>>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo Full list of available daily backups are as follows (check latest expected is available):>>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo Note: Only the last 7 days backups are retained>>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
t:
cd\
dir /b *.zip>>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt
echo.>>D:\MRCDBBACKUP.txt

net use t: /delete /y

rmdir /S /q D:\Database_%DayOfWeek%-%Month%-%Year%

 del /Q D:\MrCDb_%DayOfWeek%-%Month%-%Year%.zip

C:
cd mrc
blat D:\MRCDBBACKUP.txt -to pete@guyans.co.uk,davidguyan@mr-carpet.co.uk,davidcooper@mr-carpet.co.uk -subject "%DayOfWeek%-%Month%-%Year%: MRCDB Backup Completed"

del /Q D:\MRCDBBACKUP.txt


exit