1

Not sure if this is a false-positive issue or not, but I need quell my curiosity about it. I get the following error message:

Error: 3041, Severity: 16, State: 1.
BACKUP failed to complete the command BACKUP DATABASE DBApp. Check the backup application log for detailed messages.

I get this error fairly often, but here is the kicker, when I check the backup folder for the DB in question, the .trn & .bak file are there. So, it appears it is backing it up, but stating it failed. The backup is performed by a maintenance plan and it finishes fine while backing up all the subsequent databases.

Any thoughts or should I just completely ignore this from now on as long as the DB is listed in the backup folder?

14
  • 2
    Maybe it was the post-completion checks that failed. Maybe it didn't complete successfully - did you actually try restoring the .bak/.trn files? Just because a file is there doesn't mean it's usable. Also did you check the logs like the error message suggested? – Aaron Bertrand Oct 6 '14 at 18:13
  • 1
    There must be some message logged can you look for that this support article would help you support.microsoft.com/kb/2646329 – Shanky Oct 6 '14 at 18:52
  • Sorry about that, I forgot to mention that I did go through the SQL Error Logs. What I posted is all that was there, no further details before or after the error message. I find this strange as there is usually a detailed message – Sean Perkins Oct 6 '14 at 19:01
  • As far as the restore goes, will I receive an error if the database is corrupted in some way? I'll get to that task shortly, just trying to understand where you're leading me. – Sean Perkins Oct 6 '14 at 19:02
  • Yes it can be due to corruption. Can you run restore verify only on database backup to check its consistency. You can also try restoring backup as restore is best way to check about corruption – Shanky Oct 6 '14 at 19:06
0

Looks to be a post-completion check failure as there is no evidence elsewhere stating otherwise.

1
  • Funny, i get a negative mark on this answer, but agreed with Aaron Bertrand who has positive marks for the same answer. Must be someone looking for an easy badge instead of a legit AND easy badge. I love the internet! – Sean Perkins Aug 2 '17 at 22:33
0

Error: 3041, Severity: 16, State: 1. BACKUP failed to complete the command BACKUP DATABASE DBApp. Check the backup application log for detailed messages.

  • You will get the above error message whenever your database is in a offline state.

    Whenever you get the above error; kindly check the state of the database.

  • You can also use the following T-SQL in order to check the database details.

select * from sys.databases where name ='YourDatabaseName'

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.