Server Backups

Due to limited disk space on the HS01 & HS02 servers and the fact we don't have secondary disks to backup too, we have implemented our own backup system.

Database Backups 

Daily Access Backup

1) A scheduled tasks calls the following file C:\Backups\schedule\BackupAndZipAllAccessDatabases.bat each morning on a daily basis.
2) The bat files copies ALL mdb files in c:\web\db\ and its sub directories and zips them up to C:\web\db\1688-backup\. The zip file is datestamped.
3) A scheduled task on Necro then retrieves the dated copy of the zip file and saves it to the backup directory on Necro at \\NECRO\data\backup\files\1688\[server]\db\
4) If the dated file of the backup can not be found, an error email will be sent to support@spiderscope.com
5) The backups will be stored for 7 days and then deleted.

Daily MSSQL Backup

1) A scheduled task calls the following file C:\Backups\schedule\sql-server.bat each morning on a daily basis which creates backups of all MSSQL databases.
2) A scheduled task calls the following file C:\Backups\schedule\BackupAndZipAllMSSQLDatabases.bat each morning on a daily basis.
3) The bat files copies ALL bak files in C:\Backups\sql-server and its sub directories with todays datestamp and zips them up to C:\web\db\1688-backup\. The zip file is datestamped.
4) A scheduled task on Necro then retrieves the dated copy of the zip file and saves it to the backup directory on Necro at \\NECRO\data\backup\files\1688\[server]\db\
5) If the dated file of the backup can not be found, an error email will be sent to support@spiderscope.com
6) The backups will be stored for 7 days and then deleted.

Uploaded Files

We have 2 systems to deal with files uploaded to c:\web\upload. A daily incremental backup system and a daily full backup system that works on a round robin of customer folders.

Daily Incremental Backup

1) A scheduled task calls the following file C:\Backups\schedule\BackupAndZipModifiedUpload.bat each morning on a daily basis.
2) Any files that has been modified within the last day will be copied and zipped to C:\web\upload\1688-backup\. The zip file is datestamped.
3) A scheduled task on Necro then retrieves the dated copy of the zip file and saves it to the backup directory on Necro at \\NECRO\data\backup\files\1688\[server]\upload\incremental\
4) If the dated file of the backup can not be found, an error email will be sent to support@spiderscope.com
5) The backups will be stored for 7 days and then deleted.

Full Round Robin Backup

1) A scheduled task calls the following file C:\Backups\schedule\BackupAndZipFullUpload.bat each morning on a daily basis.
2) Depending on the week day (Mon-Sun), a specific set of directories will be fully zipped to C:\web\upload\1688-backup\. The zip file is datestamped.

The rules are:
Mon - Any folders with 0 as the 4th character in the folder name e.g. 0710, 2660, 3210
Tue - Any folders with 1 as the 4th character in the folder name e.g. 2661, 2581
Wed - Any folders with 2 as the 4th character in the folder name e.g. 2662, 3272
Thu - Any folders with 3-4 as the 4th character in the folder name e.g. 3334, 3333, 2343
Fri - Any folders with 5-6 as the 4th character in the folder name e.g. 2456, 2556, 3255
Sat - Any folders with 7-8 as the 4th character in the folder name e.g. 1987, 2788, 2898
Sun - Any folders with 9 as the 4th character in the folder name e.g. 1999, 3459

3) A scheduled task on Necro then retrieves the dated copy of the zip file and saves it to the backup directory on Necro at \\NECRO\data\backup\files\1688\[server]\upload\full\
4) If the dated file of the backup can not be found, an error email will be sent to support@spiderscope.com
5) The backups will be stored for 7 days and then deleted.

This means we will have a full backup of a customers upload directory every 7 days and any incrementals since the full backup was taken.