Backup your backup of your backup. July 7, 2020


The three most important things to remember in real estate is location, location and location. The three most important things to remember on your computer is backup, backup and backup. As you might remember, I have been working on a major update to our database which controls all aspects of our company. My primary motivation for doing this was that the software was going to require a dedicated server and server software. The second reason was that Karl, my son, had his computer crash frequently when ever he was entering work orders. I initially thought that it was a problem with the way I had programmed it but, as you may also remember, it turned out to be a bad ethernet cable. Last week, I started working on the Work Order Module and, while I knew there were some problems, I did not realize how bad it was. Out of 14 years of data, only the last two months were not corrupted. I spent two days looking at the backups I had. No one backup had all of the data so I had to restore from four different backups, the first was a 2018 year end backup and the other three were from Time Machine’s incremental backups. Once I had identified those backups, it took me about a day to make a copy of the file with good data. That file was out of sync with our regular file by a couple of days but it only took about 15 minutes to update the regular file. Now our file is completely restored and I don’t feel anal about having so many backups. A few weeks ago, I told you I had 16 different backups. One of those backups is Time Machine which automatically makes hourly backups for the past 24 hours, daily backups for the past month, and weekly backups for all previous months. The oldest backups are deleted when the backup disk is full. I have also added a separate weekly back up schedule so instead of 16 backups, I will have as many as 67 plus the incremental Time Machine backup. After what I went through last week, that doesn’t seem excessive.


Previous Quarter Next Quarter