Tag Archives: Restore

Error Msg 60400, LS::initializeFiles User Exception

Posted on February 15, 2014 by thomasrushton

Today’s error message, brought to me by SQL Server / Quest Litespeed for SQL Server: Msg 60400, Level 16, State 1, Line 0 (LS::initializeFiles) user exception Looking at the Transaction Log backup file that it was trying to restore at … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

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

Posted on February 4, 2014 by thomasrushton

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

Posted on May 21, 2013 by thomasrushton

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 thomasrushton

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 thomasrushton

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 thomasrushton

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 thomasrushton

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