Database Recovery

How to Scan and Get Always On Enabled Servers in SQL Server Environment

Maintaining a SQL Server inventory is very important. Before performing a migration project, the inventory will help a database administrator to get more detail about that server. In this article, we will learn how to scan the entire SQL environment and identify servers on which Always on has been enabled. The Best Always on Availability Groups is considered as the best high availability, disaster recovery feature in Microsoft SQL Server. It is the highly-advanced version of database...

Read more »

How to Scan and Get Log Shipped Databases in SQL Server

"Log Shipping Alert" is a job category that is created on the SQL Server instance whenever the log shipping is enabled on a database. Though this might seem to be an easy way to identify if log shipping is running on a particular SQL server, through TSQL we can scan the entire SQL Server environment to identify databases that are participating in Log Shipping. 2 tables Log shipped databases can be easily identified using two tables in msdb database. The first table is the...

Read more »

How to Read and Analyze Deadlock Logs in SQL Server

It is a well-known fact that deadlocks cannot be avoided. It is necessary that we learn to minimize deadlocks from our SQL server environment. Trace flags enable you to capture deadlock graph in the SQL Server Error log. In this article, we will learn how to get the deadlock history from that log. Deadlock Deadlock occurs when there is more than one session competing for a resource. When a deadlock occurs, SQL Server immediately jumps into action by killing one of the session and that session...

Read more »