Could not clear 'DIFFERENTIAL' bitmap in database - Error: 3041, Severity: 16, State: 1.

29 January,2019 by Jack Vamvas

Question : An error message has started appearing in the SQL Server Error Logs during a nightly full backup.

Could not clear 'DIFFERENTIAL' bitmap in database 'Database1' 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.

 

As suggested in the error message - I checked for insufficient resources and the first thing I checked was disk resources. In fact - there was only 2 MB left for the drive associated with the transaction log file.    I attempted a LOG BAKBUP but this failed , so I attempted a Shrink file on the transaction log file and a new error appeared related to : The transaction log for database is full due to LOG_BACKUP 

Reading that post outlined a few potential ideas . How should I progress?

Answer: The most important point about the ideas suggested in The transaction log for database is full due to LOG_BACKUP  , is to pick the most effective method for the particular details.

Based on information you've supplied - and the safest,  is to opt for make some extra disk space available - either through manipulating another database file on the same drive . Once you've confirmed some extra space , than issue the BACKIP LOG command. 

I like to be ultra - cautious on fixing these type of issues i.e do I have a recovery point and   proper review of underlying causes and understanding the root cause .

Apply the  FORDEC decision making process

 

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Could not clear 'DIFFERENTIAL' bitmap in database - Error: 3041, Severity: 16, State: 1.


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer