Case Study

Retail Customer with 62 stores country wide.

This is the case study on how inq Botswana overcome the issue of a complex semi-automated, backup solution for a retail customer with 62 branches, spread country-wide.

The customer has 62 branches, each with its own SQL database server per site, and run a local backup per store, per night. The database sizes varied from 10 Gb up to 75 Gb, and obviously grew daily .The backup went to an external drive, that was removed and swopped on a daily basis, the swopped drive stored offsite, in an unsecured managers homes. Once a month, drives were returned to head office to make a central copy, before being returned. This was a huge logistical management challenge. There was the cost of the devices, the transport of the devices, the time and management of copying the data at HO, the storage cost at head office, the manual management of data at head office, and the transport costs moving these drives around the country. Not only that, the data was left managers homes daily, putting data security at risk. The effort of changing and swapping drives, also led to failures of drive changes which meant entire stores data was at huge risk, as it often never left the store sites. Restoring data also became a challenge when required, finding the correct backups, transferring them to external drives, and then transporting them back to the stores, leading to long delays in system access ( especially in database corruption instances).

inq Botswana came in with our automated, electronic, secure cloud backup solution to relieve the customer of all of the complexity found in their original solution. inq BW has a central cloud backup data store in their primary DC in Gaborone. All the customers servers countrywide were loaded with a backup client. These were set to run daily backup, via existing metro connections at night ( when the link load was low), to the inq BW DC. The data is backed up & encrypted locally, then sent via secureTLS to the central cloud store at inq BW, and stored encrypted on the system. The customer controls the encryption key, and thus is the owner of the security. This immediately removed the huge logistical overhead the original solution presented. This meant no more physical drives, no more physical drive management, no more transporting of drives, no data management required at HO, no more data security risk at managers homes, and presented an efficient,ordered structure to ALL backups. With all of this, the most critical component of any backup solution became the simplest of processes, and that is the restoration of data simply, and immediately, on demand.