Monthly Archives: August 2019
Could not clear ‘DIFFERENTIAL’ bitmap in database xxx because of error 9002
The other day I was investigating an interesting issue. On a test server, we had run out of space on both data and log drives. Backups were failing due to a lack of space. Elementary, my dear Watson…. here we … Continue reading
Posted in Uncategorized
Leave a comment
Restoring a TDE-protected database backup in SQL Server
Another day, another SQL Server restore… A few days back, i had the good fortune to work on a TDE database restore. Only I didn’t really know it was TDE until I got to this part : Msg 33111, Level … Continue reading
Posted in Uncategorized
Leave a comment
Navigating the SQL Universe 