Database Recovery

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 »

How to Batch Control xp_cmdshell function on Multiple SQL Servers

xp_cmdshell is a handy function and allows SQL Server database administrators to complete tasks quickly and get transformed as a proactive and efficient database administrator. However, it also allows the user to run windows programs using the SQL Server's service account. In this article, you will learn how to control the status of xp_cmdshell from your Central Server. On a single server To check the status of xp_cmdshell on a single SQL Server instance, you can run this command from a new...

Read more »