Backing Up Accounting Software Databases: What IT Usually Gets Wrong

Accounting data is the backbone of every business — but it's routinely backed up incorrectly, making recovery impossible or causing serious data integrity errors.

An Incident Most Business Owners Don't Know Can Happen

A small manufacturing company in Da Nang contacted Vietify IT after a server failure. They had a backup — a nightly folder copy of their MISA installation directory to a NAS.

When they attempted to restore, MISA refused to open the data file:

"Error: Database is inconsistent. Please contact your vendor."

The problem: MISA uses a SQL Server database. Copying the .dat files or the MISA folder while the software is running is not sufficient — the database is in an inconsistent state when copied this way.

They lost 3 days to manual recovery and still lost 2 weeks of data.

Why Copying a Folder Is Not a Database Backup

Popular accounting and ERP software in Vietnam uses various underlying database technologies:

Software	Database	Wrong Way to Back Up	Correct Way
MISA SME	SQL Server	Copying C:\MISA folder	SQL Server Backup (.bak)
Fast Accounting	SQL Server / Pervasive	Copying .dat files	Full database dump
Bravo ERP	SQL Server	Copying the folder	VSS-aware backup
SAP Business One	SAP HANA / SQL Server	Copying the folder	SAP backup tools
CukCuk (F&B)	Cloud-based	N/A	Managed cloud backup
KiotViet	Cloud-based	N/A	Managed cloud backup

The rule: An open database file (held by SQL Server or the application) cannot be copied consistently using standard file copy. You will get a corrupted file.

How to Back Up SQL Server Databases Correctly (MISA, Fast, Bravo)

Method 1: Automated SQL Server Backup Job

This is the standard and most reliable method:

-- Run in SQL Server Management Studio
-- Create daily full backup
BACKUP DATABASE [MISA_DB] 
TO DISK = 'D:\Backups\MISA_DB_20260413.bak'
WITH COMPRESSION, CHECKSUM, FORMAT, INIT,
     NAME = 'MISA Full Backup', STATS = 10;
GO

Setting it up automatically:

Open SQL Server Agent
Create a new Job → Step 1: T-SQL backup script
Schedule: daily at 01:00 (before the overall cloud backup window)
Add email notification on failure

Result: A consistent .bak file that can be fully and reliably restored.

Method 2: VSS-Aware Backup (Veeam/Acronis)

Professional backup software like Veeam Backup & Replication and Acronis Cyber Protect use Volume Shadow Copy Service (VSS) — Microsoft's technology for creating consistent snapshots of open files.

When backing up a SQL Server with Veeam/Acronis:

VSS creates a consistent snapshot at a point in time
SQL Server is notified to flush its buffer cache to disk
Backup is taken from the snapshot — no performance impact
Resulting backup file is 100% consistent and fully restorable

Note: VSS must be explicitly enabled and verified — it is not always active by default in all configurations.

Method 3: MISA's Built-In Backup

MISA SME has an integrated backup feature:

In MISA → Utilities → Back Up Data
Set up an automatic schedule

Limitation: MISA's native backup produces a proprietary .zip or .bak file — you still need to copy this file to an offsite/cloud location. It does not automatically push to cloud storage.

Recommended Database Backup Frequency

Backup Type	Frequency	Method
Transaction Log Backup	Every 15–60 minutes (for low RPO)	SQL Server Agent
Differential Backup	Daily (during lunch break)	SQL Server Agent
Full Backup	Nightly (01:00–03:00)	SQL Server Agent + VSS
Cloud Backup	After nightly full backup	Hyper Backup / Veeam

Testing Database Backups: The Step You Cannot Skip

Insufficient: Checking that the .bak file exists Required: Actual restore to a test environment and data verification

Monthly test procedure:

-- Restore to a test database
RESTORE DATABASE [MISA_DB_TEST]
FROM DISK = 'D:\Backups\MISA_DB_20260413.bak'
WITH MOVE 'MISA_DB' TO 'D:\Test\MISA_DB_test.mdf',
     MOVE 'MISA_DB_log' TO 'D:\Test\MISA_DB_test_log.ldf',
     NORECOVERY, REPLACE;
GO

-- Check consistency
DBCC CHECKDB([MISA_DB_TEST]);
GO

Then open MISA pointing to the test database and verify:

Recent month figures match printed reports
No errors when running standard reports

Accounting Software Data That's Often Missed

Beyond the primary database, don't forget to back up:

License numbers and activation keys — losing these means purchasing new licenses or waiting for vendor reactivation
Custom configuration — chart of accounts, report templates, company settings
Attached files and invoice images — frequently stored outside the database in a separate folder
Electronic invoices (e-invoices) — must be retained per Ministry of Finance requirements
Custom Crystal Reports or report templates — often forgotten and time-consuming to recreate

Vietnamese Legal Requirements for Accounting Data Retention

Under the Accounting Law and related regulations:

Accounting documents: minimum 10 years retention
General ledger books: 10 years
Detailed ledger books: 10 years
Electronic invoices: 10 years

This means accounting backup is not just a technical matter — it is a legal obligation. You must be able to restore accounting data from 10 years ago if the tax authority requests it.

Backing up accounting data correctly is a legal obligation in Vietnam, not just good IT practice.

Accounting Data Backup Checklist

SQL Server Backup Job running daily (not just folder copying)
Backup .bak files stored at a location isolated from the production server
Nightly cloud backup covering the .bak files
Monthly restore test to a test database
Minimum 10-year retention for accounting data (legal requirement)
Attached files and invoice images backed up separately
License keys and activation details stored securely offsite

Vietify IT Supports Accounting and ERP Backup

We have hands-on experience setting up backup for:

MISA SME, MISA AMIS
Fast Accounting, Fast ERP
Bravo ERP, SAP Business One
POS software (CukCuk, KiotViet, F&B systems)

Our service includes:

Assessment of the current backup method for each system
Setting up SQL Server Backup Jobs and scheduling
Integration with the overall backup strategy (3-2-1-1)
Monthly restore testing with documented results
Compliance advice on retention requirements under Vietnamese law

Free Accounting Backup Consultation. We'll check how you're currently backing up MISA/Fast and tell you definitively whether you could actually recover from it.

Call: 0914 985 772 | vietify.vn/contact

Vietify IT Services — Accounting and ERP Data Protection Specialists in Da Nang.