Database Recovery

5 Most Important Improvements of AlwaysOn Feature in SQL Server 2016

In this article,we discuss the improvements introduced in SQL Server 2016 edition with respect to AlwaysOn Availability groups. The AlwaysOn Availability Groups or the Availability Groups feature was launched first in the 2012 edition of SQL Server. This feature is mainly used to increase the availability of a database and efficiently work towards disaster recovery. Since the launch of this feature it has continued to receive constant updates every year. This feature was launched to tackle...

Read more »

3 Quick Tips to Optimize Your SQL Server Backup Process

In this article we share some handy tips to help you optimize your backup and recovery process Often while backing up your SQL Server database, you might face problems which are complex in nature. As important is the process of backing up SQL Server data, equally important is the need to optimize the backup processes. If the process is not done right, without proper optimization, you might not be able to completely restore the backed up data or the whole process may end up consuming a lot of...

Read more »

A Deep Dive into AlwaysOn Layers Of Protection in MS SQL Server

In this article we closely examine the AlwaysOn Layers of Protection that are present in SQL Server The AlwaysOn Availability Group feature in SQL Server provides disaster recovery and fault tolerance solutions, across various layers of infrastructure and components of application. This is one of the most important features to be introduced in SQL Server. It is because of this feature that the data from one instance is available across several systems in the server. This is of great use in...

Read more »