I’ve recently been working almost exclusively on projects running SQL Server in Azure (IaaS) and the question came on the best way to handle backup and data protection. We accept that for pretty much all SQL Server based solutions we need to have data and potentially logs backups if RTO is more frequent than about … Continue reading SQL backup to Azure Blob store – a good choice ?
Recently, I noticed some very interesting side-effects from a mirror that was in a suspended state. When I went to rebuild the mirror, I had to play catch up, with DB Backups, Differential backups and TLog Backups…nothing new here. I copied the backup across (it took nearly 6 hours). The Differential was just about half … Continue reading Broken mirror on the wall, what’s the biggest backup of them all?