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.…
7 years ago
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.
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…
7 years ago
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…
8 years ago
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…
8 years ago
Understanding SQL Server Backups
SQL Server Backups are the dump of its databases that can be used to recover them in case of any…
8 years ago
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…
8 years ago
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…
14 years ago
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…
15 years ago