Like many DBAs I spend a lot of time maintaining my SQL Server backups. From SQL Server I maintain both full backups and transaction log backups. I have often restored my full backups but until recently I have never restored a transaction log backup. All backup strategy’s are only as good as the last time you tested...

I recently read a blog post by Pinal Dave about how you can backup straight to Azure Storage. The procedure he described is only available for SQL Server 2014 or later. I won’t go into detail of this method as Pinal describes it better than I can, but the basic of it requires setting up credentials and then running a...

Today is my day off, but I wake up and have a quick look at nagios to see if there is anything I need to worry about. Yes there is, SQL Server has run out of disk space on its data disk. I race downstairs and VPN onto the server to find out what has happened. One of my monitoring databases has had runaway log growth...