No database file found for ‘Microsoft SQL Server\SERVER\INSTANCE\Database’

Error

No database file found for ‘Microsoft SQL Server\SERVER\INSTANCE\Database’

Cause

This means that the database was attempted to be backed up but the backup file does not exist. It can be caused by the spooling location holding previous SQL backup jobs for databases that do not currently exist.

Resolution

Try flushing the spooling location and re-running the backup.