Tag Archives: Backup

T-SQL Tuesday #85 – Backup Compression

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?

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

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

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

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

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 , , , , | Leave a comment