Tag Archives: Maintenance

Which databases were backed up in which backup task?

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?

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 , , , , , , , | 18 Comments

Patching

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

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

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

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.

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