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,…

12

SQL Server Resource database corruption–yes, it’s possible

It’s very rare that I run into an issue with the Resource database, and the one I ran into recently was rarer still. But before I get into the nitty-gritty of the issue, let us begin by outlining a few details about the resource database: The Resource database The resource database is a hidden system…

20

SQL, Sharepoint and the Windows Internal Database – an interesting saga

This one is for all my friends out there who use Sharepoint. A default Sharepoint installation enables/installs the Windows Internal database, and creates its databases on it. The Windows Internal Database is, in a way, a special edition of SQL Server, in the sense that it’s not a Full version, but does not have the…

7