Monthly Archives: December 2009

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

Posted on December 7, 2009 by

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

Posted on December 6, 2009 by

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

Posted on December 4, 2009 by

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

Restoration of Database using SQL Server 2005 : Part II

Posted on December 4, 2009 by

In the earlier post of this series, we had discussed how to restore a database from a Full database backup file. In this series, we are going to discuss how to restore a database with a Full and a Differential … Continue reading →

Posted in Backup - Restore | Leave a comment

Restoring a Database: From Copy-Only Backup File

Posted on December 3, 2009 by

In my earlier post, I had discussed how we can take a Full database backup with Copy-Only option. We can not create a Copy-Only backup using SSMS 2005, as we need to use a T-SQL script for the same. In … Continue reading →

Posted in Backup - Restore | Leave a comment