@echo off

:Update 04-11-2013 (PG)

SET DBLOCATION=\\readynas\mrcdb

if exist C:\MRCDBBACKUP.txt del /q C:\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 %DBLOCATION% C:\Database_%DayOfWeek%-%Month%-%Year%

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

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


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


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

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

net use t: /delete /y

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

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

C:
cd mrc
blat C:\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 C:\MRCDBBACKUP.txt


exit