RE: SQL Backup failed with exit code: 882 SQL error code: 0

andriancruzandriancruz Posts: 22
edited November 23, 2015 11:31AM in SQL Backup Previous Versions
Hi Everybody,

I'd like to ask if anyone encountered this issue. I'm backing up our database using script thru SQL Agent jobs. After the backup jobs is finished i encountered error below:

Message
Executed as user: DomainUseAcct. SQL Backup failed with exit code: 882 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed.

But, when I'm checking the number of db backup files, its completed and the databases was backup completely.

Any idea why the jobs showing failed under the history but the db backup files was complete ?

Your feedback are highly appreciated. Thanks a lot!

Regards, Andrian

Comments

  • Hi andriancruz,

    The 882 error in SQL Backup is usually because one or more databases from within the SQL Agent job has been deleted. If you remove the reference to this database(s) the error should stop.

    You can remove the databases either via the wizard in the SQL Backup GUI or straight out of the SQL Agent job.

    Let me know if you need any further assistance with this.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
  • Thank you Dan for the reply.

    Regards, Andrian
Sign In or Register to comment.