Welcome!

Microservices Expo Authors: Carmen Gonzalez, Kalyan Ramanathan, Liz McMillan, Sematext Blog, Pat Romanski

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.


@MicroservicesExpo Stories
@DevOpsSummit taking place June 6-8, 2017 at Javits Center, New York City, is co-located with the 20th International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. @DevOpsSummit at Cloud Expo New York Call for Papers is now open.
Logs are continuous digital records of events generated by all components of your software stack – and they’re everywhere – your networks, servers, applications, containers and cloud infrastructure just to name a few. The data logs provide are like an X-ray for your IT infrastructure. Without logs, this lack of visibility creates operational challenges for managing modern applications that drive today’s digital businesses.
Today we can collect lots and lots of performance data. We build beautiful dashboards and even have fancy query languages to access and transform the data. Still performance data is a secret language only a couple of people understand. The more business becomes digital the more stakeholders are interested in this data including how it relates to business. Some of these people have never used a monitoring tool before. They have a question on their mind like “How is my application doing” but no id...
Information technology is an industry that has always experienced change, and the dramatic change sweeping across the industry today could not be truthfully described as the first time we've seen such widespread change impacting customer investments. However, the rate of the change, and the potential outcomes from today's digital transformation has the distinct potential to separate the industry into two camps: Organizations that see the change coming, embrace it, and successful leverage it; and...
In IT, we sometimes coin terms for things before we know exactly what they are and how they’ll be used. The resulting terms may capture a common set of aspirations and goals – as “cloud” did broadly for on-demand, self-service, and flexible computing. But such a term can also lump together diverse and even competing practices, technologies, and priorities to the point where important distinctions are glossed over and lost.
Monitoring of Docker environments is challenging. Why? Because each container typically runs a single process, has its own environment, utilizes virtual networks, or has various methods of managing storage. Traditional monitoring solutions take metrics from each server and applications they run. These servers and applications running on them are typically very static, with very long uptimes. Docker deployments are different: a set of containers may run many applications, all sharing the resource...
Keeping pace with advancements in software delivery processes and tooling is taxing even for the most proficient organizations. Point tools, platforms, open source and the increasing adoption of private and public cloud services requires strong engineering rigor – all in the face of developer demands to use the tools of choice. As Agile has settled in as a mainstream practice, now DevOps has emerged as the next wave to improve software delivery speed and output. To make DevOps work, organization...
Join Impiger for their featured webinar: ‘Cloud Computing: A Roadmap to Modern Software Delivery’ on November 10, 2016, at 12:00 pm CST. Very few companies have not experienced some impact to their IT delivery due to the evolution of cloud computing. This webinar is not about deciding whether you should entertain moving some or all of your IT to the cloud, but rather, a detailed look under the hood to help IT professionals understand how cloud adoption has evolved and what trends will impact th...
Internet of @ThingsExpo, taking place June 6-8, 2017 at the Javits Center in New York City, New York, is co-located with the 20th International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. @ThingsExpo New York Call for Papers is now open.
Without lifecycle traceability and visibility across the tool chain, stakeholders from Planning-to-Ops have limited insight and answers to who, what, when, why and how across the DevOps lifecycle. This impacts the ability to deliver high quality software at the needed velocity to drive positive business outcomes. In his session at @DevOpsSummit 19th Cloud Expo, Eric Robertson, General Manager at CollabNet, showed how customers are able to achieve a level of transparency that enables everyone fro...
You have great SaaS business app ideas. You want to turn your idea quickly into a functional and engaging proof of concept. You need to be able to modify it to meet customers' needs, and you need to deliver a complete and secure SaaS application. How could you achieve all the above and yet avoid unforeseen IT requirements that add unnecessary cost and complexity? You also want your app to be responsive in any device at any time. In his session at 19th Cloud Expo, Mark Allen, General Manager of...
The 20th International Cloud Expo has announced that its Call for Papers is open. Cloud Expo, to be held June 6-8, 2017, at the Javits Center in New York City, brings together Cloud Computing, Big Data, Internet of Things, DevOps, Containers, Microservices and WebRTC to one location. With cloud computing driving a higher percentage of enterprise IT budgets every year, it becomes increasingly important to plant your flag in this fast-expanding business opportunity. Submit your speaking proposal ...
"Dice has been around for the last 20 years. We have been helping tech professionals find new jobs and career opportunities," explained Manish Dixit, VP of Product and Engineering at Dice, in this SYS-CON.tv interview at 19th Cloud Expo, held November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA.
Rapid innovation, changing business landscapes, and new IT demands force businesses to make changes quickly. In the eyes of many, containers are at the brink of becoming a pervasive technology in enterprise IT to accelerate application delivery. In this presentation, attendees learned about the: The transformation of IT to a DevOps, microservices, and container-based architecture What are containers and how DevOps practices can operate in a container-based environment A demonstration of how ...
As we enter the final week before the 19th International Cloud Expo | @ThingsExpo in Santa Clara, CA, it's time for me to reflect on six big topics that will be important during the show. Hybrid Cloud This general-purpose term seems to provide a comfort zone for many enterprise IT managers. It sounds reassuring to be able to work with one of the major public-cloud providers like AWS or Microsoft Azure while still maintaining an on-site presence.
Between 2005 and 2020, data volumes will grow by a factor of 300 – enough data to stack CDs from the earth to the moon 162 times. This has come to be known as the ‘big data’ phenomenon. Unfortunately, traditional approaches to handling, storing and analyzing data aren’t adequate at this scale: they’re too costly, slow and physically cumbersome to keep up. Fortunately, in response a new breed of technology has emerged that is cheaper, faster and more scalable. Yet, in meeting these new needs they...
Without lifecycle traceability and visibility across the tool chain, stakeholders from Planning-to-Ops have limited insight and answers to who, what, when, why and how across the DevOps lifecycle. This impacts the ability to deliver high quality software at the needed velocity to drive positive business outcomes. In his general session at @DevOpsSummit at 19th Cloud Expo, Phil Hombledal, Solution Architect at CollabNet, discussed how customers are able to achieve a level of transparency that e...
In his session at 19th Cloud Expo, Claude Remillard, Principal Program Manager in Developer Division at Microsoft, contrasted how his team used config as code and immutable patterns for continuous delivery of microservices and apps to the cloud. He showed how the immutable patterns helps developers do away with most of the complexity of config as code-enabling scenarios such as rollback, zero downtime upgrades with far greater simplicity. He also demoed building immutable pipelines in the cloud ...
@DevOpsSummit at Cloud taking place June 6-8, 2017, at Javits Center, New York City, is co-located with the 20th International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to wait for long develop...
Get deep visibility into the performance of your databases and expert advice for performance optimization and tuning. You can't get application performance without database performance. Give everyone on the team a comprehensive view of how every aspect of the system affects performance across SQL database operations, host server and OS, virtualization resources and storage I/O. Quickly find bottlenecks and troubleshoot complex problems.