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