Monthly Archives: November 2009

Restoration of Database using SQL Server 2005 : Part I


In this series of posts, we are going to discuss how to perform database restoration using both SSMS and Transact-SQL. In case of a disaster, we should be able to restore the data till the time of failure, as early … Continue reading

Posted in Backup - Restore | Leave a comment

Copy Only Backup in SQL Server 2005


Most of the times, customers ask to refersh their development or staging database with a production copy. However, it is not recomended to create a full backup of the production DBs on demand as it breaks the differential backup chain, if you are … Continue reading

Posted in Backup - Restore | 1 Comment

Database Backup in SQL Server 2005 : Part IV


This is the final part of our series of post on Database Backup in SQL Server 2005. In the previous three posts, we discussed how to create a full / differential /t-log backup using SQL Server Management Studio. In the … Continue reading

Posted in Backup - Restore | Leave a comment

Database Backup in SQL Server 2005 : Part III


In the previous two posts, we discussed how to create a Full, Differential and Transactional-log backup of a database. We have also discussed that transactional-log backup is not supported when a database is using Simple recovery model. However, in case … Continue reading

Posted in Backup - Restore | Leave a comment

Database Backup in SQL Server 2005 : Part II


In the earlier post of this series, we discuss how to create a Full database backup using SQL Server Management Studio. In this part, we will discuss about differential database & transaction-log backup. We will continue our demonstration with “SKG_TEST” … Continue reading

Posted in Backup - Restore | Leave a comment

Database Backup in SQL Server 2005 : Part I


Database backup in SQL Server 2005 depends on the recovery model of the database. Based on this, three types of backup is possible for a database. They are: Full Database Backup Differential Database Backup Transaction Log Backup Let’s look into … Continue reading

Posted in Backup - Restore | Leave a comment

Recovery Models in SQL Server 2005


Database backup is one of the most important job which a database administrator needs to perform everyday. Since the data within the database is critical and should be available any time when a request is raised for it. Many times, … Continue reading

Posted in Backup - Restore | Leave a comment