Backup database results in error “Could not clear ‘DIFFERENTIAL’ bitmap in database”


I recently ran into yet another issue, where the error message had absolutely no relation to the final solution. When trying to back up a database, we were getting the following error:

Msg 18273, Level 16, State 1, Line 1

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. 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.

When checking the database properties, I noticed that the log file for the DB was just 504 KB in size, and it’s autogrowth was set to 1 percent. Now, since I had seen issues with keeping the autogrowth for log files low in the past (the famous VLF’s issue, which impacts startup and recovery of the DB), I suggested that we increase it. We set the Autogrowth to something like 100 MB, and voila, the backup completed successfully.

Hope this helps someone.

Comments (12)

  1. Shawn says:

    Hello there,

    I ran into the same error while setting up some maintenance plans, and your work around worked like a charm.

    Thanks for posting that!!

    –Shawn

  2. Hi Shawn…thanks so much for appreciating. Glad to know it helped.

  3. Amy says:

    Thank you so much for the work around. I was having the same issue and this worked like a charm. Thanks again for sharing.

  4. Hi Amy,

    Thanks a lot for your kind words. I'm glad you found the blog useful.

    Regards,

    Harsh

  5. Phani says:

    Thanks Harsh..It helped me resolve the issue..

  6. Thanks Phani for appreciating…glad to know it worked.

  7. Johan says:

    Thank you Harsh Deep

  8. You're very welcome Johan….thanks for appreciating.

  9. Mohammed Munawar says:

    Straight solution. Many thanks for sharing Mr. HarshDeep Singh

  10. Prem Karki says:

    Thank you for your straight work around solution.

  11. Hi Mohammed and Prem,

    Thank you so much for your kind words. I am glad to know you were able to benefit from the solution.

    Regards,

    Harsh

  12. KK says:

    It was useful for me. Thank you very much 🙂