Database Recovery

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 »

Still hanging on to SQL Server 2005 with your dear life – Upgrade Now

In this article, we will discuss why it's so important for all users to upgrade SQL Server 2005 to new editions. Since its first launch, Redmond based software giant Microsoft has released multiple editions of its SQL Server database application in a periodic manner. But there are still users who are hanging on to the more than a decade old edition of SQL Server; the 2005 edition. The extended support for the 2005 edition ended in early 2016; therefore it was imperative for all users to...

Read more »