Please use the following steps on Required file for database is missing (MS SQL database backup).
Symptom:
When performing a MS SQL database backup (VSS backup mode), the following error message is received in the backup report:
Required file "database.mdf" for database SQL_hostname\MSDB\db_name is missing.
Cause:
The message suggests that the database file of the corresponding database cannot be found in the backup destination, possible cause may be:
- Data corruption in the backup destination
Corrupted file (data blocks of the database file) deleted by the data integrity check. - Backup issue during a previous backup job
Database file was not properly uploaded to the backup destination during a previous backup.
Resolution:
Data corruption
Database file was not properly uploaded to the backup destination during a previous backup.
- Windows
For backup destination that are located on a Windows computer, check in the Event Viewer to confirm if there is any error. If a disk error is found, perform a check disk on the affected partition by entering the following command in command prompt.
chkdsk /f
- Linux
For backup destination that are located on a Linux computer, confirm if there is any error found.
cat /var/log/messages
If a disk error is found, perform a check disk on the affected partition by entering the following commands with the partition unmounted.
/sbin/fsck
/sbin/e2fsck
Backup issue during a previous backup job
Check on the previous backup reports for any error or contact Ahsay support representatives for further assistance.
For both cases, perform a Data Integrity Check with rebuild index enabled for the affected backup set, then perform a database backup afterward.
Important
The same error will still be displayed during the next 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.