Tag Archives: SQL Server 2016

Upgrading SQL Server using Availability Groups – Checklist

Posted on October 17, 2019 by thomasrushton

This is a checklist put together and followed for an upgrade of a pair of physical SQL Server 2012 servers which hosted a single availability group of several terabytes of data with minimal downtime. The availability group was configured with … Continue reading →

Posted in Uncategorized | Tagged , , , , , , | 3 Comments

Failed to Update Read-Only Database on Backup

Posted on March 3, 2019 by thomasrushton

A problem at work recently – the Netbackup-driven SQL backups were failing for just one database on a particular server. The database in question was, like one other, set to read-only. I ran DBCC CHECKDB, on the off-chance that this … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | 3 Comments

SQL Server 2016 – New Feature – Stretch DB

Posted on July 24, 2015 by thomasrushton

This applies to the CTP – it might not apply to any RTM version Have you been following the SQL Server 2016 at Microsoft.com site? I really haven’t had much time to pay attention to this recently, but this one … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | Leave a comment