What are the challenges you face when working across database platforms? Take the survey
Options

error code 915.

oberionoberion Posts: 41
edited January 30, 2006 7:33PM in SQL Backup Previous Versions
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.

Comments

  • Options
    peteypetey Posts: 2,358 New member
    SQL error code 1205 indicates a deadlock issue. Were there any other transactions running at the same time, working with the msdb..backupset table?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.