Error on completion of backup job

Question

Post reply

Error on completion of backup job

Schadenfreude-Mei

SSChampion

Points: 14083
More actions
November 20, 2008 at 7:35 am

#73106

Hey all,
I have a database that runs on sql 2k box with sp4. The maintenance plan for the two 'simple databases' recently started generating the error at the end of the backup job.
BACKUP failed to complete the command sp_executesql;1
I have no idea what it means or why this has started happening. The d atabases are part of the NETIQ AppManager suite and I have recently migrated some dbs to sql 2k5. If it helpds at all the databases are:
DM_{server}_qdb
Amppdb
Any ideas greatly appreciated.
Adam Zacks-------------------------------------------Be Nice, Or Leave

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 1

Have you tried executing the backup statement urself under mgmt. studio or query analyzer?

MJ

Schadenfreude-Mei SSChampion Points: 14083 More actions · Answer 2

Yes and i get the same response. Have narrowed it down to one database now.

Any ideas? Thanks for the response.

Adam Zacks-------------------------------------------Be Nice, Or Leave

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 3

This error indicates that the destination path to which you are taking backup does not exist or the account used to connect to the path (SQLSERVER AGENT SERVICE A/C.) is not having write access to the path.

You can change the path in MP to come known location and test it to confirm whether above is the root cause!

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc

Schadenfreude-Mei SSChampion Points: 14083 More actions · Answer 4

Sakthivel Chidambaram (11/21/2008)
This error indicates that the destination path to which you are taking backup does not exist or the account used to connect to the path (SQLSERVER AGENT SERVICE A/C.) is not having write access to the path.
You can change the path in MP to come known location and test it to confirm whether above is the root cause!

I have done this. The maintenance job backs up to an offsite DR server (which ahs always been fine and now has an issue with one database).

I have also tried backing this database up locally to the backup folder and get the same results. The backup itself actually completes fine and the data is restorable. I think it is just an erroneous message due to some sort of exception when completing the task but cant work out why?

Any ideas?

Adam Zacks-------------------------------------------Be Nice, Or Leave

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 5

Hi,

Try enabling below Trace Flags

DBCC TRACEON(3213, 3605, -1)

to Log any Exception message and much more detailed information about the backup process in the SQL log.

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc

Schadenfreude-Mei SSChampion Points: 14083 More actions · Answer 6

Sakthivel Chidambaram (11/21/2008)
Hi,
Try enabling below Trace Flags
DBCC TRACEON(3213, 3605, -1)
to Log any Exception message and much more detailed information about the backup process in the SQL log.

Hi there and thanks for your reply. I have done as you suggested and get the same result (other then trace no further error or explanation). I have attached the log, as you can see the errors occurr throughout the backup process.

This does not seem to be causing any problems but would be nice to know why it has started happening.

Thanks 🙂

Adam Zacks-------------------------------------------Be Nice, Or Leave