Data Security and Backups

Sunday 7 August 2011

What Files Should I Back Up?

Before getting answer to this question, we should know where data actually is stored or the location of data.
Let me share with you as I had came across an interesting situation with one of my clients.
Almost all the Software’s, when we install we are being asked for “program installation Directory” and thereafter where you want to save your data, as by default can be “Drive letter:\program location directory\data “, you can change this folder where you can save your data or you can also change data path externally by going thru respective file settings like .ini or .cfg. In this scenario, there was a IT person who was leaving the company and a new Techie had taken over. The previous guy had made a change where the data shall get stored to a different folder other than the default one, for our finance Software he did not pass the information to the new techie. The backup process was already in place and they continued the same way. After about a month or so, they were in a situation where they had to restore old data, when they pulled up their backup resources they could not find backup for their finance software. We were been contacted to get the data, one of our specialists went to the site and found out the data storage path was changed and those folders are not backed up. Then came the uphill task for us, to fix their data as there were some errors in data, nevertheless we worked hard and were able to retrieve their data except for last 3-4 hrs of data was lost.
It tells a lesson always verify where your data is and to confirm if there is any change in data path, whether you are doing Online Backup or transferring data to Cloud or using any other media to do backup.
I have listed out a few data / files which can be important. You can keep this as your checklist. You should backup any data which you cannot afford to loose may be your accounting records, inventory records, emails, business contacts etc.


For Businesses

Any data that is critical for your business you should back up. Remember, do not delete the original data after you backup, otherwise you are back with one copy of data. You should have at least two copies of your data and out of which one copy of your data should be off-site.

      Financial data
  §  Backup financial Software data, ERP Software data
§  Backup SQL, Oracle, or any other database used
§  Special database - or financial-software packages may store files in their
   program directories, so be sure to make copies of these, too.
§  Backup Invoices, Billings, Receipts, Payments data
§  Backup Taxation data
§  Backup payroll Software data
§  Backup  inventory Reports, Outstanding Statements of Accounts Receivables
   and Payables
§  Backup Policies, procedure Documents of Company


      MS Office Documents
§  Backup Word / Excel Spreadsheets / Power point presentation documents.
§  While most Windows users store data in their documents folder, there is also a
   tendency to keep files and folders on the Desktop.
§  Backup Desktop, My Documents folders.
§  You can also backup your entire Users folders, which is in C:\Users\Username
   in Windows 7 or Vista, C:\Documents and Settings\Username for Windows XP.
§  Backup PDF files
§  Backup legal contracts, agreements, business plans

      Business contacts and emails
§  Backup Email Dats For example Exchange Server
§  Check with your email service provider - which may offer backup services - on
   its backup and restore policies.
§  Backup Outlook, Outlook Express etc.
§  In Microsoft Outlook, mail data files are commonly located in:
            “C:\Documents and Settings\<username>\Local Settings\Application
             Data\Microsoft\Outlook\*.pst“
§  Backup your business contacts, employees information

      External Programs   
§  Backup those programs running on CEO’s / CFO’s or Executives Laptops or
   any other device that they use.
§  They may have installed some software’s and never backed up those. For
   example,I had one of our clients whose Finance Head use to a 3rd party
   Software for storing all his important notes, and he had never done backup for
   the same. Most system administrators do not look at their important
   documents nor they are being informed that those need to be backed up.

      Bookmarks or Favourites 
  §  Backup all your bookmarks, favourites in your Browser or users browser. 
  §  If you are a Firefox user, did you know that Firefox backs up your bookmarks
         all along?



For Individuals Users

Pretty much anything on your computer you feel is important you should backup. Here’s a partial list:

      MS Office Documents
§  Backup Word / Excel Spreadsheets / Power point presentation documents.
§  Backup data that is on “Desktop” as many files shall be on desktop and
   unfortunately, if  one fine day the computer does not boot up and you have to
   reinstall Operating System, desktop files shall be deleted.
§  Backup any other program file types that you use

      Music
§  Backup all music
§  Make sure not to forget, especially if you have paid for MP3’s you downloaded

      Pictures and Videos
§  Make sure you backup your pictures and videos.
§  Any time your hard drive crashes you may loose all your pictures and videos,
   you might not have paid anything for that but you shall loose all your memories
   which shall be worth much more than you paid for music downloads.

      Bookmarks or Favourites
§  Backup all your Bookmarks in your Browser
§  Backup your My Documents folder


Do Not Backup

§  Do not backup any programs, the installation files shall have to be run again.  
§  Do not backup Windows Directory folder, as you shall have to install the
   Operating System again, in case of crash.



System Image
System image is in essence a snapshot of an entire drive(s). It includes all user and system files, configuration data and applications that are present on the drive, plus information regarding disk layout and boot entries. The image can be used to recover a working Windows if your hard disk ever fails, or if you simply want to re-image your OS to an earlier point in time. You can create a System Image once everything is installed and then you can use to restore more easily everything rather than reinstalling everything manually, in case of disk failure. This is called System Image Backup. The only problem in creating such kind of backup is it occupies lot of drive space.

Hope the above helps, see you till next post.


2 comments:

  1. Its good to know.
    One Q: So Do you suggest that we should not change the default directory location?

    ReplyDelete
  2. Even if you have to change default data storage location [which sometimes is requried] you can definetely go ahead and change, but the whole thing is you should you know where your data is getting stored.

    ReplyDelete