Database Recovery

SQL Server Differential Backups – What You Must Know

In this article, we will explore the differential backup of SQL Server database in depth. In a data driven business environment, losing valuable business data is hardly an option for companies. Now if you are using SQL Server in your organization, there are lots of different options for backups you can choose and create a backup strategy as per your need. What kind of backup you choose depends on a lot of factors, and after making a selection of your backup type, you proceed towards...

Read more »

How to Choose the Appropriate SQL Server Backup Option for Your Case

In this article we look at choosing the apt backup option depending on our specific needs. Backing up data in SQL Server is an important and a challenging exercise. Like many other SQL Server processes, backup also involves a lot of factors that should be kept in mind. While backing up your data it is not only important to ensure the preservation of your data, it is also necessary for maintaining business continuity. There are different types of backups that you can use to back up your SQL...

Read more »

Understand SQL Server Clustering in Context of AlwaysOn Availability Groups

In this article, we look at Clustering in SQL Server in context of AlwaysOn Availability Groups and how both of them play together. Clustering in SQL Server refers to installing multiple instances of SQL Server in Windows Server Failover Cluster. Windows Server Failover Cluster often makes use of shared storage mainly in the form of SAN. If the cluster contains a SQL Server instance, then the user databases and the systems will also have to be on the shared storage. This will enable the...

Read more »