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
Backups
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
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
Understanding ASYNC_IO_COMPLETION Wait type in SQL Server
Normally, ASYNC_IO_COMPLETION Wait type can be seen during backup and restore activities. Whenever you will see this wait type your…
14 years ago
How to fix BACKUPBUFFER Wait Types?
Today I was working on an issue in which backup job was showing in executing state since last 2 days.Initially…
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