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

andriancruz

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

Dan B

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.

andriancruz

Thank you Dan for the reply.

Regards, Andrian