Skip to main content

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.

What to do next

Back to top