SQL Server Database Recovery

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 »

How to Find the Reason Why TempDB is Full in Your SQL Server

If the temp DB database of your SQL Server runs out of space, it can cause major disruptions in your production environment and can interrupt user applications from successful completion. If you are using a script to track temp DB size, append the script from this article to identify the root cause for the temp DB filling. Tempdb full – a common scenario Poorly written queries might create several temporary objects resulting in a growing tempdb database. This will end in disk space alerts...

Read more »