Tag Archives: Disaster Recovery

Book Review – “SQL Server Transaction Log Management” by Tony Davis and Gail Shaw

Posted on May 21, 2013 by

A couple of questions and comments on the Ask.SQLServerCentral.com website have shown some misunderstanding about the use of SQL Server’s Transaction Log files. At about the same time, I was approached by Red Gate as part of their Friends programme … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , , , , , , , | 1 Comment

RESTORE failure – error 3633… ‘DeleteTree’ … ‘fulltext.cpp’

Posted on April 5, 2013 by

Here’s a little bit of the pain that I’m facing today. I was trying a SQL Server RESTORE (using Quest’s Litespeed for SQL Server) of one of our databases, one that has a fulltext index. The restore was consistently failing … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , , | Leave a comment

Bulk Restores – response to a question on Ask SQLServerCentral

Posted on January 24, 2013 by

Here’s the scenario: You’re rebuilding a DR environment, and have a set of Full, Differential and transaction log backups to restore. How to script this to run with minimal interference? The Approach Assumptions: All your backups are in subdirectories named … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment

Protecting Yourself from Disaster

Posted on January 8, 2013 by

One of Steve Jones’s latest “Voice of the DBA” podcasts, “The $50,000 Laptop”, got me thinking. In particular, in the last, short, paragraph: Encrypting the laptop almost cuts the loss in half. Now, that I’m not sure about – except … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

Unmitigated Disaster? Or was it also a Learning Experience?

Posted on November 6, 2012 by

The Situation You get a call. Someone has done something bad – in this case, failed to select the WHERE clause when running an UPDATE statement against your production database. Oops. Leaving aside thoughts of “why is he messing with … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | 1 Comment

Bulk Restores – Which Database is Restoring Now?

Posted on October 25, 2012 by

As I discussed in an earlier post, I’ve been looking at backup & restore operations and the length of time they take to complete. It has, with further use, come to my attention that the final query presented doesn’t necessarily … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment

Terry Pratchett on Disaster Recovery

Posted on November 13, 2011 by

Cast your minds back to T-SQL Tuesday 19, on the subject of Disaster Recovery. In one of my two posts, I said Practice makes perfect. But even when you’ve practised DR until you’re blue in the face, there’s always something … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

T-SQL Tuesday #19 – Data Disasters

Posted on June 14, 2011 by

T-SQL Tuesday is a monthly event on the second Tuesday of each month; various SQL Server bloggers write about a specific topic, and *you* can join the party. This month’s topic was chosen by Allen Kinsel (blog|twitter), is “Disasters & … Continue reading →

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , | 3 Comments

T-SQL Tuesday #19 – DR all done. Really?

Posted on June 14, 2011 by

T-SQL Tuesday is a monthly event on the second Tuesday of each month; various SQL Server bloggers write about a specific topic, and *you* can join the party. This month’s topic was chosen by Allen Kinsel (blog|twitter), is “Disasters & … Continue reading →

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , , , | 1 Comment