Database Solutions

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 »

Why We should Set Recovery Objectives before Recovery Strategies?

In this article we discuss the need for setting recovery objectives before we formulate our backup and recovery strategy. Before defining the backup and recovery process for SQL databases in your organization, you need to first formulate your recovery objectives. Key component in Database recovery solutions is the Redundancy of Data. All the transactions taking place in your SQL Server instance are applied to the secondary storage synchronously or asynchronously. During an outage, an online...

Read more »

2 Fatal Considerations for a Point-in-time Restore in SQL Server Database

In this post, users will get to know various considerations that are important for performing a point-in-time restore. The considerations are related to type of recovery model and the information contained in the log chain. Introduction There can be times when an administrator wants to restore the database back to a previous point from the past. The restore can be a part of SQL recovery process. Reasons for this can be many. But, mostly it happens due to malicious DDL or DML statement or due...

Read more »