SQL Server Database Recovery

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 »

Learn about the different database states – Ms SQL Server Basics

In this article we look at the states in which the SQL Server database can operate. There are seven states in which SQL Server can operate. All these states are denoted by differences in their performance, the results produced and the ease of use. A database can operate in only one of these states at any given time. You can find out the current state of your database by selecting state_desc column present in the sys.databases catalog view. There are different reasons for the occurrence of...

Read more »