Database backup error

• p.ramchander

  Ten Centuries

  Points: 1171

  More actions

  November 15, 2012 at 6:43 am

  #270304

  Hi,

  I'm trying to backup a database and i am getting the following error.

  System.Data.SqlClient.SqlError: Could not clear 'DIFFERENTIAL' bitmap in database 'db name' 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.....

  Your help is much appreciated.

• Scott D. Jacobson

  SSCertifiable

  Points: 6149

  More actions

  November 15, 2012 at 7:05 am

  #1559342

  Is this at all helpful? http://blogs.msdn.com/b/sqljourney/archive/2012/06/26/backup-database-results-in-error-could-not-clear-differential-bitmap-in-database.aspx

• p.ramchander

  Ten Centuries

  Points: 1171

  More actions

  November 15, 2012 at 7:09 am

  #1559346

  Thanks for the pointer scott. It worked for me.