Monthly Archives: December 2009

How to check the version of SQL Server currently running on our instance?


Usually I visit the MSDN forums on a daily basis. One of the common questions which I found in the forum is How to check the version of SQL Server currently running on our instance? There is an article in … Continue reading

Posted in SQL Server Versions | Leave a comment

Restoration of Database using SQL Server 2005 : Part IV


In this post, we will see how to restore a database using Transact SQL query language. So let’s start with the database restoration from a full backup file. i. Restoration of a Database from a Full Backup File: In this … Continue reading

Posted in Backup - Restore | Leave a comment

Restoration of Database using SQL Server 2005 : Part III


In my previous post, we have discussed how to restore a database from a Full and a Differential data backup file. In this post, we are going to discuss, how to restore a database from both data and log backup … Continue reading

Posted in Backup - Restore | Leave a comment