SQL Server Database Recovery

How to Monitor the Availability of Your SQL Server Database Backup Files

Every DBA uses backup file as the basis to recover a corrupted SQL Server database. SQL Server's maintenance plan helps you to create Backup plans. You can then schedule those maintenance plans as jobs though SQL Server agent. However you will not receive any alert if these backup files get corrupted or moved or deleted from the backup path. This article will help you to identify if all databases in your SQL environment has a backup file that can be used during a disaster recovery. Start with...

Read more »

9 Practical Applications of SQL Server Transact SQL (T-SQL)

In this article we look at Transact SQL and look at its 9 practical applications SQL basically stands for Structured Query Language meaning SQL server makes use of a structured language for taking in queries and sending relevant information. All RDBMS make use of a standard query language for processing data, but not all of them necessarily use the same language. Many software have taken from SQL, and modified it a bit, turning it into another language for their software. T-SQL has been...

Read more »

How to Sharpen your Disaster Recovery Plan by Setting KPIs

In this article we understand why it is important to set KPIs for any disaster recovery plan that you create for your SQL Server implementation. There is a lot that goes into creating an efficient disaster recovery plan that is suitable for not only fighting all kinds of disasters, but is also able to recover multiple data forms. Although any organization would aim to create a plan suitable for all situations, the plan might not end up being as good as the organization would want it to be....

Read more »