Database Solutions

How to Plan for Both Sporadic and Chronic Incidents in a SQL Server Disaster Recovery Plan

In this article we consider contingencies to deal with both chronic and sporadic incidents and formulate a comprehensive SQL Server disaster recovery plan. While creating a disaster recovery plan for SQL Server data, your plan should not just be aimed at protecting the assets, but also focus on what kind of assets is it meant for. A lot of thought and planning goes into creating a disaster recovery plan, and you should always create a plan depending on what kind of data do you count as...

Read more »

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 »