Database Solutions

Important Facts about SQL Server Transaction Log Files

In this section, we will talk about what exactly are transaction logs in an SQL Server database. What purpose do they solve and how they come in to play in case of disaster recovery plan. What is a Transaction Log? It’s basically a file. These files are extremely important for every server database. The file contains all the records that are used to log the activities in the database. It happens to be the most crucial part of servers if we talk about their usage during SQL server recovery...

Read more »

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 »