Tag Archives: Disaster Recovery

Note to self re: restoring backups of read-only databases

Restoring a full backup of a Read-Only database: fine. Then restoring a diff backup of that same database: won’t work. I’ve just wasted best part of a day chasing that one down. What’s worse is I should have remembered, as … Continue reading

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

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

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’

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

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

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?

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?

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