2

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?

Improve this question
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
    Commented Oct 6, 2014 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
    Commented Oct 6, 2014 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
    – AKDiscer
    Commented Oct 6, 2014 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.
    – AKDiscer
    Commented Oct 6, 2014 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
    Commented Oct 6, 2014 at 19:06

2 Answers 2

Reset to default
0

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

Improve this answer
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!
    – AKDiscer
    Commented Aug 2, 2017 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'

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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