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