Tag Archives: Backup

Failed to Update Read-Only Database on Backup

Posted on March 3, 2019 by thomasrushton

A problem at work recently – the Netbackup-driven SQL backups were failing for just one database on a particular server. The database in question was, like one other, set to read-only. I ran DBCC CHECKDB, on the off-chance that this … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | 3 Comments

Redgate SQLPrompt – Backup your code snippets

Posted on January 15, 2019 by thomasrushton

You’ve got a new computer? And you want to copy your code snippets over? Or you’ve got a new colleague and want to share your stuff? Or you’ve got multiple machines an want to keep snippets in sync? You’ll want … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

T-SQL Tuesday #85 – Backup Compression

Posted on December 13, 2016 by thomasrushton

T-SQL Tuesday time again. First one I’ve taken part in for over a year – oops. This time, Kenneth Fisher (blog|@sqlstudent144) is hosting a blog party about backups. So here’s a quick post about Backup Compression. Backup Compression Told you. … Continue reading →

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

Which databases were backed up in which backup task?

Posted on July 18, 2016 by thomasrushton

It’s a confusing question / title / headline. Let’s see if I can clarify what I’m after. For each scheduled backup job, which databases were backed up? And (more to the point) which databases weren’t backed up? And how can … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | 3 Comments

SQL Jobs – On a Calendar?

Posted on April 30, 2016 by thomasrushton

SQL Server backup jobs are IO-intensive, he says, stating the obvious. When you have a lot of servers which have been set up over the years, and you’re new to the environment, and want to see when storage is being … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , , , , | 19 Comments

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

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

Protecting Yourself from Disaster

Posted on January 8, 2013 by thomasrushton

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

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