Backing Up Databases With The dbatools PowerShell Module
We do a lot of database backups and restores at work, outside of our regular backup routines. A lot! I’ve actually done as many as 40 in one day. Our …
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 …
Resolving Write Error When Backing Up Database Master Key
This blog post is more for my own personal notes so that I don’t bang my head against the wall so much next time, but hopefully it will help someone …
Using Ola Hallengren’s SQL Server Maintenance Solution with SQL Server Express Edition
This post is just a quick extension of my earlier post on Automating backups for SQL Server 2008 R2 Express Edition. If you’d rather use Ola Hallengren’s SQL Server Maintenance …
Automating backups for SQL Server 2008 R2 Express Edition
One of the limitations of SQL Server Express is that you can’t automate backups in it via the SQL Server Agent like you can the other versions of SQL Server. …