Database Recovery

How to Get More Juice Out of a Secondary Replica on an AlwaysOn Availability Groups in SQL Server

In this article, we understand how to make the most out of secondary replica for AlwaysOn Availability Groups. Users working on SQL Server are familiar with AlwaysOn feature available in 2012 and subsequent editions. AlwaysOn availability groups help users in providing higher availability, read scale balancing and disaster recovery. There is an Active Primary replica and along with is a secondary replica which is passive. So the essential question is how can we assign certain tasks to...

Read more »

5 SQL Server Worst Practices You Must Avoid at All Costs

In this article, we have addressed some of the most common mistakes and worst practices users should avoid at any cost. Worst practices or common errors can vary from business to team; or team to business. Just like finding a solution for any problem, the first step here also is for the user to recognize the problem. Once the user is acquainted with the problems, or errors he is more likely to avoid them in the future. Here is a list of some of the worst practices that you can go through...

Read more »

10 Key Questions You Should Ask before Formulating a Disaster Recovery Plan for SQL Server

Know the key questions you need to ask while you are working on a Disaster recovery plan. Although it is a given that all organizations making use of SQL Server should also be making use of a disaster recovery plan, there are certain situations that end up putting you in a situation where your disaster recovery plan does not end up being as good as it was expected. What will be your way out in this kind of a situation? What will you do if there is a disaster and you are unable to perform...

Read more »