Backup & Recovery

Find the list of articles, tips & tricks about SQL Server Backup & Recovery. Read from basics to advanced configuration steps. You will get troubleshooting tips to fix the Backup & Recovery issues in this section as well.

Restore a Database Participating in Alwayson Availability Group

Sometimes, we need to restore a database that is part of always on availability group to fulfill our business needs.…

Fix SQL Server Error 3023: Shrink failed for LogFile “Log File Name”

Today, I got below Microsoft SQL Server error 3023 when I was trying to manually shrink a log file. The…

SQL Server Backup & Recovery Interview Questions & Answers

This article is based on SQL Server backup & recovery interview questions and answers. You can access SQL Server Architecture…

Understanding Backup Preferences for AlwaysOn Availability Group Databases

We know SQL Server Backups are resource intensive operation that strain on I/O and CPU (with backup compression). AlwaysOn Availability…

Understanding SQL Server Backups

SQL Server Backups are the dump of its databases that can be used to recover them in case of any…

Understanding SQL Server Recovery Model

A Recovery Model is a database property that designed to control transaction log maintenance. SQL Server Recovery Model does not…

How to Recover or Repair Suspect Database in SQL Server

Suspect database in SQL Server is not very common issue but there are times we face it because of various…

Understanding Point in Time Recovery in SQL Server

Point In Time recovery is a process to recover or restore your database till the point it was lost. Sometimes…