Tag Archives: Restore

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

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

Warning: Wordbreaker, filter or protocol handler used by catalog ‘foo’ does not exist.

Posted on June 21, 2012 by

While monitoring database restores in the DR environment, as you should do, I noticed the following warning message: Warning: Wordbreaker, filter, or protocol handler used by catalog ‘foo_FullText’ does not exist on this instance. Use sp_help_fulltext_catalog_components and sp_help_fulltext_system_components check for … Continue reading →

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