SQL backup fails with V-79-65323-18273 - Could not clear 'DIFFERENTIAL' bitmap in database 'database_name' because of error 9002
book
Article ID: 100028969
calendar_today
Updated On:
Description
Error Message
V-79-65323-18273 - Could not clear 'DIFFERENTIAL' bitmap in database 'RS_newTempDB' because of error 9002.
As a result, the differential or bulk-logged bitmap overstates the amount of change that will occur with the next differential or log backup. This discrepancy might slow down later differential or log backup operations and cause the backup sets to be larger than necessary.
Cause
Typically, the cause of this error is insufficient resources. Investigate the failure and resolve the cause. If the error occurred on a data backup, consider taking a data backup to create a new base for future differential backups.
Resolution
If this error is observed:
- Check the database properties and if the log appears to be too small in size, adjust the Autogrowth setting to allow it to grow larger.
- If there are a large number of logs, perform a log backup so that committed data can be removed and the log will be smaller.
- Check the disk space available for the drive hosting the logs, and free up space if the drive is near capacity.
- Perform a new full backup if a differential was being performed
Issue/Introduction
SQL backup fails with V-79-65323-18273 - Could not clear 'DIFFERENTIAL' bitmap in database because of error 9002
Additional Information
UMI: V-79-65323-18273
Was this article helpful?
thumb_up
Yes
thumb_down
No