Database Recovery

A Quick lowdown on SQL Server Clusters

In this article we take an in-depth look into SQL Server clusters and learn how they can prove beneficial to an organization. Clustering in SQL Server refers to the installation of multiple instances of SQL Server into one or more physical servers, preferably ones running on Microsoft Windows. This is done to add on to the availability of the database, as a clustered SQL Server database will be available across the clustered servers at all times. So in case either of the server crashes, the...

Read more »

Understand the Relevance of Archiving Data in SQL Server

In this article we look at why it is important to archive data in SQL Server Archiving data refers to separately storing data that is currently not in use, but might be used for future purposes. Archived data is stored separately from the data currently in use so that excess data does not slow down the performance. It is important to archive data in SQL server as databases are usually very heavy files, and storing all databases, even those not in use on a single system will affect...

Read more »

SQL Server Maintenance Tips for Mid Sized firms

In this article we look at how mid sized firms can establish the recovery protocol for SQL Server instances implemented in their organization. In-case of most mid size firm, their primary technical requirement is that SQL Server should work continuously and effectively. They do not concentrate much on its efficiency or getting the most of it, primarily because there is not much data to deal with in a mid size firm as compared to a large scale enterprise. Maintenance tips are very crucial...

Read more »