- "... a scholar and a true gentleman." - Buck Woody, Microsoft's "Real World" SQL Server DBA.
Friend of Redgate
-
Recent Posts
Tags
Agresso AskSSC Backup Book Review Books Career CTE DBCC Denali Design Disaster Recovery Education ETL Full Text Indexes Indexing Installation IT Management Kaseya Maintenance Maintenance Plans Management Meme Monday Migration Monitoring MSDB Normalization Performance PowerShell Programming red-gate Restore SQLBits SQLSaturday SQL Server 2000 SQL Server 2005 SQL Server 2012 SSMS T-SQL T-SQL Tuesday Training Upgrade User Group Windows 2012 WordPress WTFArchives
Categories
SQL Server blogs
SQL Server Resolution
Tag Archives: Backup
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 Backup, Book Review, Books, Disaster Recovery, Maintenance, Maintenance Plans, Management, Performance, red-gate, Restore, Transaction Log
1 Comment
Bulk Restores – response to a question on Ask SQLServerCentral
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 AskSSC, Backup, Disaster Recovery, Restore, T-SQL
Leave a comment
Protecting Yourself from Disaster
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
Bulk Restores – Which Database is Restoring Now?
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 Backup, Disaster Recovery, Management, Restore, T-SQL
Leave a comment
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 Backup, Full Text Indexes, Maintenance, Restore, T-SQL
Leave a comment
Non-Production Servers – SIMPLE recovery?
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
How long before that backup completes?
An early start this morning, as I need to back up a big reporting database before the guys at work start running some heavy optimisation process to rationalise and compress the data. However, I don’t necessarily know how long the … Continue reading
T-SQL Tuesday #16 – Aggregates and Average Weekly Backup Sizes
T-SQL Tuesday this month is hosted by Jes Borland. T-SQL Tuesday, which occurs on the second Tuesday of each month, provides an opportunity for many SQL Server bloggers to come together to discuss a single issue, selected by the host … Continue reading
Posted in SQLServerPedia Syndication, T-SQL Tuesday
Tagged Backup, CTE, MSDB, T-SQL, T-SQL Tuesday
1 Comment
