Database Recovery

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 »

A quick introduction to files and filegroups in SQL Server

In this article we take a close look at the structure of files and filegroups present in SQL Server SQL Server makes use of binary files and not textual files and it consists of two types of files Log files and Data files; these can further be grouped into Filegroups for the purpose of allocation and administration. Data files understandably consist of data and objects like tables, indexes, views etc. Log files on the other hand keep a record of all transactions and also stores information...

Read more »