Enhancements in SQL Server 2014 for Availability and Disaster Recovery


There has been few new versions of SQL Server released of recent which include SQL Server 2012 and the latest being SQL Server 2014. There are many new features introduced with SQL Server 2014 and there has been many enhancements to the existing features of database engine, SSRS, SSIS and SSAS. Below are list of some of the important Enhancements in SQL Server 2014 for Availability and Disaster Recovery.

Enhancements to Always On Availability Groups which now support up to 8 replicas instead of 4 as in SQL Server 2012. If primary replica or quorum is unavailable, then the secondary replica will still be available as read-only, instead of the Availability group going offline as in SQL Server 2012. Also, now Availability Groups can use SQL Azure for DR purposes rather than creating a secondary Data Centre just for that. Also, SQL Server 2014 allows the hosting of Availability Group data files in Azure, hosting an entire replica in a Windows Azure VM, and performing backups to a URL to store in Windows Azure Blob Storage. Failover cluster instances (FCIs) can now use Cluster Shared Volumes (CSVs) as cluster shared disks. Many new New DMVs and functions have been introduced with SQL Server 2014.

There are also few security enhancements like Native Backup Encryption which allows DBAs to get rid of the 3-rd party tools with same functionality. Connect Any Database permission allows a login to connect to any database existing or future without having to configure connect privileges on every database Impersonate Any Login allows a login to impersonate any other login, without giving them sysadmin privileges. Also it can use be used to deny impersonation even for logins that inherently have the right to do so. Select All User Securables allows SELECT, but not INSERT/UPDATE/DELETE/MERGE permissions on all user tables in all user databases. Useful for auditors or anyone who needs a read only role across all databases, without having to configure things like db_datareader or individual object-level permissions in every database.

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2014

SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings


Leave a Reply

Your email address will not be published. Required fields are marked *