SQL Server Database Recovery

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 »

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 »