Database Recovery

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 »

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 »