Database Recovery

SQL Server Database Mirroring Technique – Advantages and Disadvantages

In this post, we have talked about database mirroring, which is basically a high availability and disaster recovery technique. The post delves deeper into its advantages/disadvantages and how to create an environment for this technique. When you talk about protecting SQL server from sudden unpleasant surprises such as natural disasters or human errors, backups offers a great source of relief. If you are a database administrator, you must have wished at some point that there existed an...

Read more »

SQL Server High Availability and Disaster Recovery – An Overview

This post outlines a summary of the meaning and need of High Availability and Disaster Recovery in SQL Servers. The post further explains various High Availability solutions. What are High Availability and Disaster Recovery? High availability refers to the process of measuring how a system remains accessible in case a system component fails. Conventionally, to implement it, multiple levels of load balancing and/or fault tolerance capabilities are built.  Disaster recovery, on the other hand...

Read more »

3 Provisions to Ensure Your SQL Server Database is Disaster Ready

The aim of this post is give users some insight on how to check whether an SQL backup and restore strategy is functional. The post also explains how administrators can check whether or not the system is disaster ready. 1.Managing Backup Media There are certain provisions that every backup plan designed to recover SQL Server database must have. The provisions are aimed at managing backup media which are described below: A plan for overwriting backup media. Management and tracking...

Read more »