SQL Server Solutions

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 »

How to Read and Analyze Backup Failure Logs in SQL Server

SQL Server database backups help companies avoid data losses and recover from database corruptions quickly. You can create alerts to let the database administration team know about failing backup jobs. However, it is also equally important to keep a track of backup failures and work on the root causes. In this article, we will learn how to analyze backup failures Backup Failures The backup job might fail because of network or hardware or even due to human errors. Though hardware and human...

Read more »