Database Recovery

How to Create a SQL Server Disaster Recovery Plan

In this article we look at creating SQL Disaster Recovery plan which is customized as per your priorities. For many SQL users, disaster recovery means being able to recover data in the time of a disaster. This is not what disaster recovery is limited to; this is only a part of disaster recovery. In its true sense, disaster recovery involves the ability to revive all SQL related business operations during a disaster. Regular backups too are only a part of the recovery strategy, you need to...

Read more »

6 Key Steps to Follow when Shrinking a SQL Server Log File

In this article we look at the process of shrinking transaction log files in Ms SQL Server SQL Server allows you to shrink log files to effectively free up space in quick time. It might happen that your log files do not make use of the entire space available in the transaction log files, to make full use of the available space, you can opt for shrinking the log files. Usually you can shrink your log file only when your database is online, or a single, virtual log file is not in use....

Read more »

How to Get the Usage Statistics of Your SQL Server Databases

When working in a very large SQL Server environment, it is very common that no one in the organization knows who uses a particular database. This scenario is very common if there are multiple legacy systems. Follow this article to identify how effectively your SQL Server databases are used. Method 1: In this method, we are going to read the output of sp_who2 and capture it in a table. The first step is to create the table using this script. CREATE TABLE T1 (     session_id INT   ...

Read more »