Welcome!

@CloudExpo Authors: Pat Romanski, Liz McMillan, Elizabeth White, Kevin Jackson, Sanjay Zalavadia

Related Topics: Cloud Security, Microservices Expo, IoT User Interface, Agile Computing, @CloudExpo

Cloud Security: Article

What You Should Know Before Your Computer Crashes

How important is your Outlook and QuickBooks data?

Imagine it as if it's actually happened - your network has crashed and all your organization's critical applications and associated data have vanished. This worst-case scenario is one every business owner fears. Whether it's due to a storm, a break-in or the crash of your hard drive, the loss of your company data can cripple your business, leaving you stranded and holding the proverbial bag.

Business owners often assume that they don't have time to think about data backup procedures, much less the recovery process involved in the event of a system failure. They are focused instead on the business at hand. Unfortunately, what many don't realize is that the stalwart back-up methods of the past such as tape, CD or memory stick have become painfully antiquated in today's data-centric world.

While many small-to-mid-sized businesses (SMBs) think all of their data is being captured and stored in a safe place, the reality is that most SMBs are operating under a false assumption. Your business depends on mission-critical applications and their associated data. The deep dark secret is that many of these programs are not being backed up because, when left open, they are outside the parameters of standard backup procedures.

The question all business owners should ask themselves is simple: "If my computer disappeared tomorrow, could my business survive without past emails, contacts, work schedules and accounting data?" If the answer is no, then it's time to take a closer look at your backup and data recovery procedures.

The Ongoing Dilemma

Many critical non-standard databases, such as Outlook and QuickBooks along with other accounting software and legacy applications, as well as databases such as MS Access and MySQL, are not VSS-aware, meaning they lack the standard that allows files or databases to be backed up when in use. This lack of functionality leaves many IT managers and SMBs empty-handed in the event of a disaster or system failure.

Outlook and QuickBooks user/company data is notorious for being left out of standard backup routine practices. The ongoing dilemma of backing up this critical data continues to be the fact that most of us forget to shut down these programs when we leave for the day. Unless you take special precautions, it is likely that when attempting to restore these critical data files you may find that they are outdated... or worse, corrupted. This is true of many mission-critical programs that keep your business running.

Take Outlook for example; a critical application for businesses of all sizes. If Outlook is not closed, many backup tools are unable to backup the ever-important .PST file, leaving your company open to potential disaster should the program crash. The .PST contains all of your Outlook data, including emails, calendar events, contacts, schedules and notes; and the backup of this file doesn't necessarily happen automatically. Backing up the .PST file is critical for restoring your most recent data.

Additionally, for those of us who are email hoarders, keeping all email correspondence in Outlook over the past year can cause the .PST to reach gigabyte proportions very quickly. These large and unruly files can produce unexpected problems when backing them up. Many backup systems can "time out" or even worse, demand an extra tape or CD to complete the backup routine when your office is closed and employees are gone for the day.

A good starting point is to look for a Microsoft Certified backup vendor that follows the best practices set by Microsoft. Selecting back up software that doesn't conflict with Windows or other low-level drivers, such as antivirus programs and software firewalls, should be a key element in identifying a backup vendor.

When it comes to ranking important data, most people place their financial records near the top of the list. This is especially true for business owners. QuickBooks, the popular accounting software, is another application many SMBs can't do without. The absence of an Application Programming Interface (API) presents additional challenges for protecting corporate financial data. An API allows third-party companies to integrate special functions, such as requests for a data dump for easy backup. Currently, there is no safe method to programmatically dump your QuickBooks data to a safe place for easy backup at the end of the day, and without an API, developers can't create one for QuickBooks.

Intuit recommends scheduling QuickBooks to back up automatically to a specific folder, which allows your data to be verified regularly, and from there, scheduling your third party backup software to back up to that folder. This ensures that QuickBooks is in a good state before your backup software runs. Not following these best practices could lead to a corrupted QuickBooks database file.

Listed below are the QuickBooks files that your company must make sure are backed up:

.QBW = quickbooks Primary Data File

.QBB = quickbooks Backup File

.QBA = quickbooks Accountant's Copy File

(May also be a .AIF [Accountant's Import File])

.QBA.TLG = Transaction log file (for the accountant's review copy)

.QBM = quickbooks Portable Company File (for version 2006 and above).

.QBI = quickbooks Crash Roll Back File

.QBX = quickbooks Accountant Transfer File

.QDT = quickbooks United Kingdom Accountant Data File

The backup challenges of these programs are unique, so take the time to consider alternatives that address this lack of functionality. Some data backup companies provide solutions that include the ability to continuously back up your programs and data, no matter where that device is located and even while the programs are open and in use.

How Confident Are You? - Not Sure? Test It!
Not sure if your data is secure? Just like a fire drill, the best way to make sure is to put your backup method to the test. If possible, locate a spare computer, wipe the drive and attempt to do a complete restore of your company applications and associated data. Then ask yourself the following questions:

  • Are you able to restore your backup files in one simple step?
  • Do you need to re-install all of your applications individually?
  • Do you have easy access to those applications and have you kept track of the associated upgrades?
  • Does your Outlook, QuickBooks and other proprietary data install easily?
  • Do you end up with the most current data when you have completed the restoration?

Most important, keep track of the time it takes you to complete the restoration from beginning to end, then multiply that by the number of computers you have within your organization. Many SMBs are unaware that the "dirty little secret" of data recovery is the time it takes to restore data, which is governed by your company's bandwidth restrictions. When your computers are down, every minute counts.

Conclusion
Data backup should be as important to your business as an insurance policy. Computers can be replaced if lost in a disaster, or stolen during a break-in. But if you don't have a reliable, secure method of restoring your data, all the money in the world isn't going to bring back those missing files. It is crucial to find a method that protects every level of your data.

In a perfect world, there would be no need to back up your company's data; computers and hard drives would last forever, outside threats like malicious hackers and natural disasters would be non-existent and employees would never forget to save a file, or close a program. Unfortunately this perfect world does not exist. For this reason, businesses of all types and sizes know that keeping their data backed up and protected at all times must be of the utmost priority if they wish to remain in business after the fact.

More Stories By Jamie Brenzel

Jamie Brenzel brings over 15 years of experience in investment banking and entrepreneurial startups to his role as CEO of KineticD. His prior business accomplishments are long and varied. He was at Salomon Brothers in London, where he helped build the equity derivatives department into an important profit center. He then embarked on his future as an entrepreneur, acquiring Wood Printing & Graphics, and later co-founding integrated marketing communications company Sonar Group. Jamie then established a solid foundation for Truition, an eCommerce service company for clients such as Dell Financial Services, CompUSA and Sirius Satellite Radio. Jamie holds an Honors Bachelor of Arts degree in Politics and Philosophy from the University of Western Ontario.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


@CloudExpo Stories
"We work in the area of Big Data analytics and Big Data analytics is a very crowded space - you have Hadoop, ETL, warehousing, visualization and there's a lot of effort trying to get these tools to talk to each other," explained Mukund Deshpande, head of the Analytics practice at Accelerite, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York City, NY.
Edge Hosting has announced a partnership with and the availability of CloudFlare, a web application firewall, CDN and DDoS mitigation service. “This partnership enhances Edge Hosting’s world class, perimeter layer, application (layer 7) defensive mechanism,” said Mark Houpt, Edge Hosting CISO. “The goal was to enable a new layer of customer controlled defense and compliance through the application of DDoS filters and mitigations, the web application firewall (WAF) feature and the added benefit ...
Redis is not only the fastest database, but it is the most popular among the new wave of databases running in containers. Redis speeds up just about every data interaction between your users or operational systems. In his session at 19th Cloud Expo, Dave Nielsen, Developer Advocate, Redis Labs, will share the functions and data structures used to solve everyday use cases that are driving Redis' popularity.
"SpeedyCloud's specialty lies in providing cloud services - we provide IaaS for Internet and enterprises companies," explained Hao Yu, CEO and co-founder of SpeedyCloud, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York City, NY.
Your business relies on your applications and your employees to stay in business. Whether you develop apps or manage business critical apps that help fuel your business, what happens when users experience sluggish performance? You and all technical teams across the organization – application, network, operations, among others, as well as, those outside the organization, like ISPs and third-party providers – are called in to solve the problem.
Creating replica copies to tolerate a certain number of failures is easy, but very expensive at cloud-scale. Conventional RAID has lower overhead, but it is limited in the number of failures it can tolerate. And the management is like herding cats (overseeing capacity, rebuilds, migrations, and degraded performance). Download Slide Deck: ▸ Here In his general session at 18th Cloud Expo, Scott Cleland, Senior Director of Product Marketing for the HGST Cloud Infrastructure Business Unit, discusse...
Unless your company can spend a lot of money on new technology, re-engineering your environment and hiring a comprehensive cybersecurity team, you will most likely move to the cloud or seek external service partnerships. In his session at 18th Cloud Expo, Darren Guccione, CEO of Keeper Security, revealed what you need to know when it comes to encryption in the cloud.
The cloud promises new levels of agility and cost-savings for Big Data, data warehousing and analytics. But it’s challenging to understand all the options – from IaaS and PaaS to newer services like HaaS (Hadoop as a Service) and BDaaS (Big Data as a Service). In her session at @BigDataExpo at @ThingsExpo, Hannah Smalltree, a director at Cazena, provided an educational overview of emerging “as-a-service” options for Big Data in the cloud. This is critical background for IT and data profession...
"Tintri was started in 2008 with the express purpose of building a storage appliance that is ideal for virtualized environments. We support a lot of different hypervisor platforms from VMware to OpenStack to Hyper-V," explained Dan Florea, Director of Product Management at Tintri, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York City, NY.
Machine Learning helps make complex systems more efficient. By applying advanced Machine Learning techniques such as Cognitive Fingerprinting, wind project operators can utilize these tools to learn from collected data, detect regular patterns, and optimize their own operations. In his session at 18th Cloud Expo, Stuart Gillen, Director of Business Development at SparkCognition, discussed how research has demonstrated the value of Machine Learning in delivering next generation analytics to imp...
It's easy to assume that your app will run on a fast and reliable network. The reality for your app's users, though, is often a slow, unreliable network with spotty coverage. What happens when the network doesn't work, or when the device is in airplane mode? You get unhappy, frustrated users. An offline-first app is an app that works, without error, when there is no network connection. In his session at 18th Cloud Expo, Bradley Holt, a Developer Advocate with IBM Cloud Data Services, discussed...
In the world of DevOps there are ‘known good practices’ – aka ‘patterns’ – and ‘known bad practices’ – aka ‘anti-patterns.' Many of these patterns and anti-patterns have been developed from real world experience, especially by the early adopters of DevOps theory; but many are more feasible in theory than in practice, especially for more recent entrants to the DevOps scene. In this power panel at @DevOpsSummit at 18th Cloud Expo, moderated by DevOps Conference Chair Andi Mann, panelists discusse...
A strange thing is happening along the way to the Internet of Things, namely far too many devices to work with and manage. It has become clear that we'll need much higher efficiency user experiences that can allow us to more easily and scalably work with the thousands of devices that will soon be in each of our lives. Enter the conversational interface revolution, combining bots we can literally talk with, gesture to, and even direct with our thoughts, with embedded artificial intelligence, wh...
Connected devices and the industrial internet are growing exponentially every year with Cisco expecting 50 billion devices to be in operation by 2020. In this period of growth, location-based insights are becoming invaluable to many businesses as they adopt new connected technologies. Knowing when and where these devices connect from is critical for a number of scenarios in supply chain management, disaster management, emergency response, M2M, location marketing and more. In his session at @Th...
As organizations shift towards IT-as-a-service models, the need for managing and protecting data residing across physical, virtual, and now cloud environments grows with it. Commvault can ensure protection, access and E-Discovery of your data – whether in a private cloud, a Service Provider delivered public cloud, or a hybrid cloud environment – across the heterogeneous enterprise. In his general session at 18th Cloud Expo, Randy De Meno, Chief Technologist - Windows Products and Microsoft Part...
In his keynote at 18th Cloud Expo, Andrew Keys, Co-Founder of ConsenSys Enterprise, provided an overview of the evolution of the Internet and the Database and the future of their combination – the Blockchain. Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life sett...
What does it look like when you have access to cloud infrastructure and platform under the same roof? Let’s talk about the different layers of Technology as a Service: who cares, what runs where, and how does it all fit together. In his session at 18th Cloud Expo, Phil Jackson, Lead Technology Evangelist at SoftLayer, an IBM company, spoke about the picture being painted by IBM Cloud and how the tools being crafted can help fill the gaps in your IT infrastructure.
Cloud Expo, Inc. has announced today that Andi Mann returns to 'DevOps at Cloud Expo 2016' as Conference Chair The @DevOpsSummit at Cloud Expo will take place on November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. "DevOps is set to be one of the most profound disruptions to hit IT in decades," said Andi Mann. "It is a natural extension of cloud computing, and I have seen both firsthand and in independent research the fantastic results DevOps delivers. So I am excited t...
"delaPlex is a software development company. We do team-based outsourcing development," explained Mark Rivers, COO and Co-founder of delaPlex Software, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York City, NY.
University of Colorado Athletics has selected FORTRUST, Colorado’s only Tier III Gold certified data center, as their official data center and colocation services provider, FORTRUST announced today. A nationally recognized and prominent collegiate athletics program, CU provides a high quality and comprehensive student-athlete experience. The program sponsors 17 varsity teams and in their history, the Colorado Buffaloes have collected an impressive 28 national championships. Maintaining uptime...