Category Archives: Backup – Restore

Why my Differential Backup was Failing?

Posted on November 17, 2012 by

In one of the online SQL forum, a forum user reported that, one of their server is scheduled for a weekly full database backup & daily differential database backup. However, during mid of this week, the daily differential job failed … Continue reading →

Posted in Backup - Restore, Jobs, SQL Server | Tagged , , | Leave a comment

Rebuild MSDB Database

Posted on June 19, 2012 by

I had accidentally deleted the transaction log file of msdb database on a newly installed SQL Server 2008 R2 instance yesterday, while I was removing the old tempdb files. Although I normally copy the system database files prior removing the … Continue reading →

Posted in Backup - Restore, Disaster Recovery, How To, Just Learned, SQL Server, SQLCMD | Tagged , , , , , | 2 Comments

Restore Database WITH RESTART

Posted on April 12, 2012 by

Last night, I was migrating a production database  from SQL Server 2005 to SQL Server 2008 environment. While the restoration script was running, failover happened due to a network failure. When the SQL instance started on the other node, all the … Continue reading →

Posted in Backup - Restore, How To, Just Learned, SQL Server | Tagged , , , | 3 Comments

Shrinking Transaction log

Posted on February 6, 2012 by

Some days back, I had a discussion with one of my colleague about Shrinking a database log file. He told me that they had a database with a log size 10 times larger than the data file size, and they … Continue reading →

Posted in Backup - Restore, SQL Server, T-Log | Tagged , | 2 Comments

Deleting a Database!!! Did you take a Backup?

Posted on January 14, 2012 by

We all took backup of our databases, that’s a habit now rather than a task, correct?? However, did you take a backup before dropping a database? If not, you might consider to take a Full database backup before deleting a … Continue reading →

Posted in Backup - Restore, SQL Server | Tagged , | Leave a comment

Tail-log Backup without the Primary Data File

Posted on April 15, 2011 by

While I was reading a post, written by Vinod Kumar (blog | twitter) about Files and FileGroups with SQL Server, I found an interesting quiz question: “Do we need the primary data file available to backup your transaction log after a crash?“ … Continue reading →

Posted in Backup - Restore, SQL Server, T-Log | 6 Comments

Backup a database from one server and restore the same on the other server?

Posted on March 27, 2010 by

Well, this is a common question, which is asked frequently on MSDN forums, so think of writing a quick note on how to do the same. The scenario is as follows: Scenario: Say we have two database servers, ServerA and … Continue reading →

Posted in Backup - Restore | 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