Sequentur Blog

Helping you stay ahead of IT challenges

Real-world IT knowledge from engineers solving problems every day.

Practical IT knowledge for businesses that can’t afford downtime

How to back up QuickBooks and other critical business applications

Jember,,East,Java,,Indonesia,,May,31,,2018.,Quickbooks,Self-employed,App

QuickBooks is the accounting backbone for millions of small businesses, and most of them are not backing it up correctly. The built-in backup feature in QuickBooks Desktop creates a .QBB file that captures the company file at a single point in time. Many business owners treat this as sufficient. It is not. A .QBB backup sitting on the same computer as the company file does not protect against hardware failure, ransomware, or theft. A .QBB backup on a USB drive in the desk drawer does not protect against fire or flood. And QuickBooks Online users often assume Intuit handles backup entirely, which is only partially true.

QuickBooks is not the only application with this problem. Sage, practice management software, point-of-sale systems, and dozens of other line-of-business applications have their own backup limitations that business owners either do not know about or work around with manual processes that eventually break down. If you are also evaluating moving these LOB apps to cloud (as either a SaaS replacement or a lift-and-shift to cloud-hosted infrastructure), how to move line-of-business applications to the cloud covers the migration paths and what to watch for.

This guide covers how to back up QuickBooks properly, why the default approach falls short, and how to think about backup for any critical business application that stores data locally or in a vendor’s cloud.

Why copying the QuickBooks file is not enough

The most common QuickBooks “backup” in small businesses is someone copying the .QBW company file to a USB drive or a shared folder. This feels like a backup because the file exists in a second location. The problem is that copying a QuickBooks company file while QuickBooks is running can produce a corrupted copy.

QuickBooks Desktop uses a multi-file database structure. The .QBW file is the primary company file, but QuickBooks also maintains transaction log files (.TLG) and network descriptor files (.ND) that track the state of the database. When you copy the .QBW file directly, you are copying the database at whatever state it happens to be in at that moment. If a transaction is partially written, if the file is being indexed, or if QuickBooks is in the middle of a write operation, the copy may be internally inconsistent.

An inconsistent company file might open without errors. It might even look normal for weeks. Then one day a report does not balance, a customer payment is missing, or the file refuses to open entirely. The corruption was baked in at the time of the copy, but it was not visible until something triggered it.

QuickBooks’ built-in backup tool (File > Back Up Company > Create Local Backup) avoids this problem by verifying file integrity before creating the backup. It writes a .QBB compressed backup file that is a verified, consistent snapshot. But even this approach has limitations.

QuickBooks Desktop backup limitations

Single point-in-time recovery

A QuickBooks .QBB backup captures the company file at the exact moment the backup runs. If you run a backup every Friday evening, and your hard drive fails on Thursday afternoon, you lose up to six days of accounting work. Every invoice, payment, journal entry, and reconciliation from the past week is gone.

For a business that processes dozens of transactions daily, six days of lost data means hours or days of manual re-entry, assuming you can even reconstruct the transactions from source documents. Some transactions – manual journal entries, adjustments, write-offs – may not have source documents at all.

No automated scheduling (without workarounds)

QuickBooks Desktop can schedule automatic backups, but the feature is unreliable. It requires QuickBooks to be open and running at the scheduled time. If someone closes QuickBooks before leaving for the day, the scheduled backup does not run. If the computer restarts overnight for updates, the backup does not run. If QuickBooks crashes, the backup does not run. There is no alert when the scheduled backup fails to execute.

Many businesses set up scheduled backups once, assume they are running, and never verify. Months later they discover the last successful backup was from the initial setup.

Local storage only

QuickBooks’ built-in backup writes the .QBB file to a local or network destination. It does not natively support cloud backup. The backup sits on the same computer, an external drive, or a network share, all of which are vulnerable to the same threats as the original file – ransomware that encrypts the network, a fire that destroys the office, or a hardware failure that takes out both the primary drive and the USB backup plugged into the same machine.

This violates the most basic principle of the 3-2-1 backup rule: at least one copy must be offsite. A QuickBooks backup on a USB drive in the same building as the computer is not offsite.

Multi-user complications

In multi-user environments where several people access QuickBooks simultaneously, backup becomes more complex. The built-in backup requires all other users to log out before it can run. In practice, this means someone has to coordinate with the team to ensure everyone exits QuickBooks at the scheduled backup time, or the backup has to run outside business hours when nobody is logged in – which brings back the problem of QuickBooks needing to be open.

QuickBooks Online vs Desktop backup

QuickBooks Online (QBO) is a different product with a different backup story. Because QBO runs in Intuit’s cloud, many business owners assume their data is fully protected. Intuit does maintain redundant infrastructure and disaster recovery for their platform. Your data is unlikely to be lost due to a hardware failure at Intuit’s data center.

But Intuit’s infrastructure protection does not cover every data loss scenario:

Accidental deletion. If someone deletes transactions, customers, or vendors in QBO, those deletions are permanent. QBO does not have an “undo” that reaches back days or weeks. Intuit’s backup protects against infrastructure failure, not user error.

Malicious changes. If a disgruntled employee modifies financial records before leaving, or if a compromised account is used to alter data, the changes are now the “current” state. Intuit does not maintain point-in-time snapshots that you can restore to.

Account compromise. If an attacker gains access to your QBO account and deletes or exports your data, Intuit’s support process for recovering deleted data is limited and slow. This is the same shared responsibility model that applies to Microsoft 365 backup – the platform provider protects the infrastructure, but you are responsible for protecting the data from user-level threats.

Intuit policy changes. If your subscription lapses or Intuit changes their data retention policy, access to historical data may be affected. Maintaining your own backup ensures you are not entirely dependent on a third party’s policies.

Third-party backup solutions for QBO (Rewind, Intuit Data Protect, and others) connect to your QBO account via API and maintain independent copies of your accounting data. These provide point-in-time recovery that the platform itself does not offer.

How to back up QuickBooks properly

QuickBooks Desktop

The right approach combines QuickBooks’ built-in backup with a server-level or application-aware backup solution:

Step 1: Use the built-in backup as a first layer. Configure QuickBooks to create a local .QBB backup to a network share or secondary drive. Run it at least daily. Verify it runs by checking the backup file dates weekly, not just assuming the schedule is working.

Step 2: Include the QuickBooks data folder in your server backup. Your server backup solution should capture the entire directory where QuickBooks stores its company files. This is typically C:\Users\Public\Documents\Intuit\QuickBooks\Company Files or a custom path your IT person configured.

Step 3: Use application-aware backup. An application-aware backup solution uses VSS (Volume Shadow Copy Service) to create a consistent snapshot of the QuickBooks data files before backing them up. This solves the corruption problem that comes from copying files while QuickBooks is running. Most modern backup software (Veeam, Acronis, Datto, Axcient) supports VSS snapshots by default.

Step 4: Ensure offsite copies. The server backup that includes QuickBooks data should replicate to an offsite location – cloud storage, a secondary site, or at minimum a rotated offsite drive. The QuickBooks data needs to follow the same offsite rules as everything else on the server.

Step 5: Test the restore. Restore the QuickBooks company file from backup to a test location at least quarterly. Open it in QuickBooks and verify the data is intact – check recent transactions, run a balance sheet, and confirm the file opens without errors. A backup that produces a corrupted or incomplete company file is not a backup.

QuickBooks Online

Use a third-party backup service. Connect a backup tool (Rewind, OwnBackup, or similar) to your QBO account. These tools take daily snapshots of your accounting data and store them independently from Intuit’s infrastructure. They provide granular restore – you can recover individual transactions, customers, or vendors without restoring the entire account.

Export critical reports regularly. As a secondary measure, export key reports (trial balance, P&L, balance sheet, customer list, vendor list) to PDF or Excel monthly and store them in a location separate from QBO. This is not a substitute for backup, but it provides a reference point if you need to verify or reconstruct data.

Secure the account. Enable multi-factor authentication on all QBO user accounts. Limit admin access to the fewest people possible. Review the user list quarterly and remove former employees immediately. Account security is the first line of defense against the data loss scenarios that Intuit’s infrastructure protection does not cover.

Other business applications with backup gaps

QuickBooks is the most common example, but the same backup challenges apply to other applications that small businesses depend on.

Sage (Sage 50, Sage 100)

Sage products store data in proprietary database formats that are vulnerable to the same file-copy corruption issues as QuickBooks. Sage 50 uses a Pervasive/Actian database engine, and copying the data files while Sage is running can produce an inconsistent backup. Sage 100 (formerly MAS 90/200) uses a similar architecture.

The fix is the same: application-aware backup that uses VSS snapshots, not file-level copies of the database while the application is running.

Practice management software

Law firms, medical practices, dental offices, and accounting firms use industry-specific practice management software (Dentrix, Open Dental, PracticePanther, Clio, Timeslips, and dozens of others). Many of these applications store data in local SQL Server or proprietary databases.

On-premises versions need the same application-aware backup approach as QuickBooks. The database files must be backed up using VSS or the application’s own backup utility, not by copying files directly.

Cloud-hosted versions have the same shared responsibility issue as QBO. The vendor protects their infrastructure, but user-level data loss (deletions, modifications, account compromise) is your responsibility. Check whether your vendor offers point-in-time recovery and what their data retention policy is. If they do not, consider a third-party backup.

For healthcare practices specifically, backup is not optional – HIPAA requires that covered entities maintain retrievable copies of electronic protected health information. A practice management system without proper backup is a compliance violation.

Point-of-sale (POS) systems

Square, Toast, Shopify POS, and similar cloud-based POS systems store transaction data in the vendor’s cloud. The data is generally well-protected at the infrastructure level, but historical data access depends on your subscription level and the vendor’s retention policy. If you cancel or downgrade, you may lose access to historical data.

On-premises POS systems store data locally and need the same backup treatment as any local database. The transaction data, inventory records, and customer information should be included in your server backup scope.

Custom or legacy applications

The riskiest category. Older applications, custom-built software, or industry-specific tools that nobody else uses may store data in unexpected locations, use proprietary file formats, or have no documented backup procedure. These applications are often the hardest to replace and the least likely to be properly backed up.

For any custom or legacy application, document:

  • Where does it store data? (file path, database, registry)
  • Can the data be exported to a standard format?
  • Is there a built-in backup utility?
  • Does it support VSS snapshots?
  • What is the restore procedure if the server is rebuilt from scratch?

If you cannot answer these questions, your backup for that application is incomplete regardless of whether the backup software reports success.

Application-aware backup vs file-level backup

This distinction is critical for understanding why some backup approaches work for business applications and others do not.

File-level backup copies files as they exist on disk. It reads the file, copies the bytes, and stores the copy. This works perfectly for documents, spreadsheets, images, and any static file. It does not work reliably for databases or applications that maintain open file handles and write data continuously.

Application-aware backup coordinates with the application before taking the backup. On Windows, this typically uses VSS (Volume Shadow Copy Service). The backup software tells VSS it is about to take a snapshot. VSS tells the application (QuickBooks, SQL Server, Sage, Exchange) to flush its buffers, complete any pending writes, and freeze briefly. The snapshot is taken from this consistent state. The application resumes normal operation, and the backup reads from the frozen snapshot.

The result is a backup that contains a consistent, point-in-time view of the application’s data. No partial writes, no missing transactions, no corrupted indexes. The application was not interrupted, and the backup is reliable.

Most modern backup solutions support VSS by default, but it needs to be enabled and configured correctly. If your backup software is doing file-level copies of your QuickBooks or Sage data directory without VSS, you are at risk of backing up corrupted data.

Backup frequency for financial applications

Financial applications deserve more frequent backup than general file storage. The data changes constantly throughout the business day, and every transaction represents work that is painful to recreate.

Application typeRecommended backup frequencyWhy
Accounting (QuickBooks, Sage, Xero)Every 4-8 hours or real-timeHigh transaction volume, hard to reconstruct entries
Practice managementDaily minimum, every 4-8 hours preferredClient records, billing, scheduling
POS / inventoryReal-time or hourly during business hoursTransaction data lost permanently if not captured
ERP / manufacturingReal-time replicationComplex interdependent data, high re-entry cost
General file storageDailyLower change rate, easier to recreate

For QuickBooks Desktop specifically, achieving better-than-daily backup requires either continuous data protection (CDP) at the server level or moving to a backup solution that captures changes more frequently than the built-in daily .QBB backup. This is where a server-level backup solution with 4-hour or hourly snapshots adds significant value.

How Sequentur handles application backup

When we onboard a new client, one of the first things we audit is how their critical business applications are being backed up. QuickBooks, Sage, practice management systems, and other line-of-business applications get specific attention because they are the applications where data loss hurts most and where default backup approaches are most likely to fail.

We configure application-aware backup for every database-backed application, verify that VSS snapshots are working correctly, and set backup frequency based on each application’s transaction volume and the business’s recovery requirements. QuickBooks data typically gets backed up every 4 to 8 hours with both local and cloud copies, ensuring the business can recover to within a few hours of any incident.

We also test application restores specifically – not just verifying that files exist in the backup, but restoring the company file to a test environment and confirming it opens, balances, and contains current data. A QuickBooks backup that restores a file from three months ago because the recent backups were silently corrupted is not a functioning backup.

If your business relies on QuickBooks, Sage, or any other application where data loss would directly affect operations, and you are not confident that your current backup captures that data correctly, reach out through our contact page. We can audit your application backup configuration and show you exactly what is and is not protected.

Get the Best IT Support

Schedule a 15-minute call to see if we’re the right partner for your success.

Invalid Email
Invalid Number
Please check the captcha to verify you are not a robot.
Testimonials

What Our Clients Say

Here is why you are going to love working with Sequentur

Need help?

FAQs About Our Managed IT Services