How can we help you today? How can we help you today?

error code 915.

Hi, I've a scheduled job that backup transaction log every 1 hour. It has been running pretty good for the last few days. Today, however, I got the following:
Executed as user: DC01\SQLSERVER_DBA. SQL Backup job failed with exitcode: 915 SQL error code: 1205 [SQLSTATE 42000] (Error 50000). The step failed.

The v4.0 chm file states:
915 Failed to update backup history table (BACKUPSET).

Why did this happen and how can I prevent it from happening in the future?

Thanks.
oberion
0

Comments

1 comment

Sort by
  • petey
    SQL error code 1205 indicates a deadlock issue. Were there any other transactions running at the same time, working with the msdb..backupset table?
    petey
    0

Add comment

Please sign in to leave a comment.