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?

more ▼

asked Sep 21, 2010 at 12:17 AM in Default

pits gravatar image

830 83 91 92

Like it says, have you checked the logs?
Sep 21, 2010 at 01:05 AM ThomasRushton ♦
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first
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.
more ▼

answered Sep 21, 2010 at 04:28 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

(comments are locked)
10|1200 characters needed characters left

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
more ▼

answered Sep 21, 2010 at 01:51 AM

Adiga gravatar image

221 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 21, 2010 at 12:17 AM

Seen: 1856 times

Last Updated: Sep 21, 2010 at 12:51 AM