It is generally known throughout the SQL Server world that having multiple log files on a database is not a good idea. While multiple data files spread across multiple drives …
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 …
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. …
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 …
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 …
When it comes to everyday routine maintenance of your SQL Server databases, you can’t beat Ola Hallengren’s SQL Server Maintenance Solution. Focusing on SQL Server Backups, SQL Server Integrity Checks, and SQL Server …
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 …
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. …
