Backup Integrity – Why It Is So Important?

In this article we explore why it is important to maintain backup integrity. Although backing up of data is indispensable, there are occasions, when a backup might prove to be more harmful than helpful. While backing up data, you might not realize, but it might get corrupted. And you will come to know about it only when you attempt to use the backups for restoration of data. In such a situation, a backup file proves to be more of a problem than a solution. A corrupted backup might fail...

Read more »

5 Main Functions of the Transaction Logs in SQL Server

In this article we look at the key functions of transaction logs in SQL Server Transaction Log, as the name suggests, keeps a log of all the transactions that are taking place; along with the database modifications it’s making each day. It is one of the most crucial element in your database, in case of any system failure it brings back database to a consistent condition. You should never opt for deleting or moving your transactions log unless you are not completely sure of its...

Read more »

Understanding the Types of Failovers in SQL Server AlwaysOn Availability Groups

In this article, we look into failover options present in AlwaysOn Availability groups in MS SQL Server In layman’s terms, AlwaysOn Availability Groups can be considered as a form of disaster recovery solution which also helps in increasing the availability of database. Availability Groups support failovers in SQL Server. And it is important to note that failovers are not caused due to any issues with database, such as corruption or unavailability. The failover environment is supported by...

Read more »