Table of Contents

[V7] ISSUE: No database file found (MS SQL database backup)

Article ID: 5318
Reviewed: 2018-03-13

Product Version:
AhsayOBM: 7.3.0.0 to 7.x
OS: Windows

ATTENTION 1st January, 2022: v7 officially End-of-Life [details]

Problem Description

When performing a MS SQL database backup (ODBC backup mode), the following error message is received in the backup report:

No. Type Timestamp Log
* ... ... ...
* info ... No full file found for in-file delta backup files. Path="SQL_hostname\...\db_name.bak".
* erro YYYY/MM/DD hh:mm:ss No database file found for "SQL_hostname\...\db_name"
* ... ... ...

Cause

The message suggests that the database file of the corresponding database cannot be found in the backup destination, possible cause may be:

Resolution

To resolve the issue, refer to the following steps:

For both cases, perform a Data Integrity Check for the affected backup set (Instruction), then perform a Full database backup afterward.

Important:
The same error will still be displayed during the next Full database backup job, the problem will be resolved after the database file is uploaded properly. Do not interrupt the database backup job when an error is displayed.

Keywords

sql, odbc, require, required, miss, missed, missing