Yes, there are backup application log files and they can be very helpful in figuring out the cause of a backup failure. In my case I was getting the "Backup BACKUP failed to complete the command BACKUP DATABASE database_name. Check the backup application log for detailed messages.", "Backup Error: 3041, Severity: 16, State: 1" error like the following:
Checking the log file, which on my server is located in the "SQL\MSSQL12.MSSQLSERVER\MSSQL\Log" folder, I get the following:
No comments:
Post a Comment
Thank you for commenting!