Member Since: 20th Jun 2015
28th Jul 2018
Sadly, this is quite an old article, and ExcelZone and the Excel spreadsheet example mentioned here are no longer on the website.... I was looking at it out of personal interest, too.
18th Sep 2017
Over 30 years ago I was taught about data backup with a "grandfather, father, son" model keeping a daily backup of changes ('son'), weekly full backup ('father') and a monthly full backup too.AndrewV12 wrote:
we are all told the cloud is the way forward, but this has got us all worried...
Of course, more copies better than less (so do a monthly backup on month change, followed by week1, week2, week3)... and now and then add a new test file, delete it from the disk after backup, and be sure it could be retrieved a week or two later...
Nowadays you need to update to keep one backup on the cloud, one off site (eg at a director's home) and another locked away at the office. Multiply backups as much as you feel able to (a) afford and (b) not reduce general productivity, and you should be safer... not just ready for GDPR, DPA, and in case of flood or fire, but be protected against data encryption / blackmail too.
Amazon has a service called Glacier for long term storage of large quantities of data, so copy (encrypted) backups there and fingers crossed never need to retrieve them. Then make use of Carbonite or similar (or 1000 GB of Microsoft storage) for weekly and daily backups.
Don't tear your hair out, but ask your IT support staff / firm what they have in place. Whatever else, however, do keep at least one copy on drive/ drives that are taken off site and stored elsewhere for at least a week.