Category Archives: Backup – Restore

Why my Differential Backup was Failing?


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


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


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 , , , | 5 Comments

Shrinking Transaction log


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?


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


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 | 8 Comments

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


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