Corruption With Backup Compression And TDE In SQL 2017
Last week I spent a good bit of time dealing with a corruption issue, and as it turns out I may actually have found a bug in SQL Server 2017. …
SQL Scripts: How To Make Sure Your Backup Is Valid
I recently had a case where I needed to download a database backup to my laptop. It usually takes about 12 hours for this particular backup to copy down, so …
Fixing “Possible Date Calculation Spin For Schedule” Error
I recently ran into a strange error when trying to modify a SQL Agent job. This was an existing job that had been created a year or so ago, and …