Post reply

Error on completion of backup job

  • 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

  • November 20, 2008 at 2:45 pm

    #901305

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

    MJ

  • November 21, 2008 at 2:59 am

    #901506

    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

  • November 21, 2008 at 3:25 am

    #901515

    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

  • November 21, 2008 at 5:17 am

    #901545

    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

  • November 21, 2008 at 11:11 pm

    #901971

    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

  • November 24, 2008 at 4:36 am

    #902360

    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

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

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