Tag 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

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