Tag Archives: Maintenance

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

Patching

Posted on August 11, 2013 by thomasrushton

We had a communication from an Ops team saying that they intended to apply Windows patches to all our SQL Servers in one six hour period. This just felt wrong, on so many levels, including: QA, UAT, DR, Production all … Continue reading →

Posted in Uncategorized | 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

T-SQL Tuesday #35 – Soylent Inbox

Posted on October 9, 2012 by thomasrushton

T-SQL Tuesday is a monthly SQL Server blogging event.  One of us sets a topic for the month’s event, and we all have a week in which to write a blog post that fits that topic.  This month’s event is … Continue reading →

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

Querying SQL Server Event Logs to search for DBCC CheckDB output

Posted on September 12, 2012 by thomasrushton

This is a long-winded response to a query raised on AskSSC, about how to report on the running of DBCC. One way suggested was to use Ola Hallengren’s scripts to schedule and report. However, I have another way that I … Continue reading →

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

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

Red Gate – SQL Server Index Manager – Beta 2

Posted on April 25, 2012 by thomasrushton

Red Gate released the first Beta for their new Index Manager back in December, and I blogged about it then.  They have recently updated the Beta, and so I downloaded it and had another play. First attempt to use it, … Continue reading →

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

Non-Production Servers – SIMPLE recovery?

Posted on December 22, 2011 by thomasrushton

Speaking of putting databases into SIMPLE recovery mode… This post is based on what I use on non-production (eg for QA, or UAT) replicas of production environments – the sort of thing where you need the data, but don’t need … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 6 Comments

Red Gate – SQL Index Manager – Beta

Posted on December 16, 2011 by thomasrushton

Once again, those lovely chaps at Red Gate have come up with a new tool for the DBA – SQL Index Manager, and Grant “Scary” Fritchey (blog|twitter) has even done a video about it on YouTube. So, let’s download it … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 6 Comments