Create and Verify a Manual Database Backup
How to Create and Verify a Manual Database Backup in Muhasib ERP
Overview
This guide will help you create a SQL Server.bak backup and prove it is usable through controlled verification.
SQL Server creates a database backup file; file existence alone does not prove recoverability.
Who can do this
You need access to Backup & Restore access, SQL Server backup rights, and filesystem access to the selected server-visible location.
Before you start
Confirm active database, backup destination, free space, encryption/retention policy, maintenance window, and unique filename.
Before saving, check that the correct company is open and that you have permission to complete this task.
Where to find it
Back Office → Essentials Setup → Backup and Restore → manual backup.
Create and Verify a Manual Database Backup
Step 1: Confirm the intended company database and record its identity
Step 2: Select an approved .bak destination visible to SQL Server
Step 3: Start backup once and wait for the success message
Step 4: Confirm file exists with plausible size and timestamp
Step 5: Record database/version/date and checksum/hash where policy requires
Step 6: Test restore into an isolated non-production database
Check your work
An isolated restore opens successfully and key company, settings, master, and transaction control totals match.
Take a moment to check your work before closing the window. This small check can save time later.
If something goes wrong
- SQL Server service identity, not only the desktop user, needs path access.
- Never overwrite the only known-good backup.
Related guides
- Restore a Database Backup Safely
- Configure Automatic Database Backups
- Recover from a Database or Startup Failure