I have a new SQL2005 database with several databases on it. I have a pretty de-facto backup (from using the backup wizard) that does a full backup of the user databases every night.
Yesterday I added a new database and it won't backup. The errors are
2009-11-11 15:09:32.70 Backup Error: 3041, Severity: 16, State: 1.
2009-11-11 15:09:32.70 Backup BACKUP failed to complete the command BACKUP DATABASE Database. Check the backup application log for detailed messages.
2009-11-11 15:11:18.57 spid99 Error: 18204, Severity: 16, State: 1.
2009-11-11 15:11:18.57 spid99 BackupDiskFile::CreateMedia: Backup device 'N:\Backups\Userdatabases\Database\Database _backup_200911111511.bak' failed to create. Operating system error 3(error not found).
2009-11-11 15:11:18.57 Backup Error: 3041, Severity: 16, State: 1.
I've migrated another database on today and that backups up fine to the same area.
The issue seems to be creating the files in the sub-directory \Userdatabases\Database\
The job runs fine if it doesn't create the sub-directory for each database.