How To Resolve Backup Failed

Overview:

In QNE Optimum, database backups are essential for protecting your financial data. However, a “Backup Failed” error may occasionally occur when a previously scheduled backup did not complete successfully, leaving a .bak file in the SQL instance’s DATA folder. This article will guide you through resolving this issue

Scenario:

You attempt to back up your QNE database, but the system displays a "Backup Failed – Backup Database Failed" message. The error indicates that it cannot open the backup device located in the DATA folder (e.g., C:\Program Files\Microsoft SQL Server\MSSQL11.QNEBSS\MSSQL\DATA). This issue often occurs when a previous .bak file is still present and has become locked, corrupted, or restricted.

Procedure:

Step 1: Locate the Problem Folder

• On the error prompt, take note of the full file path to the DATA folder.

• Navigate to that folder using File Explorer.

Example path: C:\Program Files\Microsoft SQL Server\MSSQL11.QNEBSS\MSSQL\DATA

Step 2: Identify and Remove the Existing .bak File

• Look for the .bak file named similarly to your company database (e.g., ABC_Trading.bak).

• Right-click the file and choose either:

• Delete, or

• Move it to another folder (e.g., desktop or backup archive) for safekeeping.

Application:

After completing the steps, the backup should proceed successfully without errors.