question

pits avatar image
pits asked

BACKUP command failed

I am using sql 2008 enterprise version received below error message, BACKUP failed to complete the command BACKUP DATABASE John_Mimi. Check the backup application log for detailed messages. Noticed in SQL error logs,there is below message. > Source Backup Message Error: 3041, > Severity: 16, State: 1. Can any expert let me what is this all about, and why back up command failed? Rgds,
sql-server-2008backuperrorenterprise-edition
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Like it says, have you checked the logs?
0 Likes 0 ·

2 Answers

·
Adiga avatar image
Adiga answered
What is the type of BACKUP that you are trying to take? FULL, DIFFERENTIAL OR LOG? If it is DIFFERENTIAL OR LOG, you may be trying to take the backup where the FULL backup does not exist. Please refer the below links. http://support.microsoft.com/kb/921106/ http://support.microsoft.com/kb/928317
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
You need to look at the logs. It's possible that you're using a third party product for the backups. That app may also have logs you need to check. Those logs should tell you what the problem is.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.