Tag Archives: Backup/Recovery

Problems With Database Problems

Gitlab had a database problem recently. I’m sure you read about it. There have been commentaries from many people, including Brent Ozar and Mike Walsh. There are many ways to look at this outage and data loss (the extent of … Continue reading

Posted in Editorial | Tagged | 2 Comments

T-SQL Tuesday #85–Cross Version Restores

It’s T-SQL Tuesday time, and this month Ken Fisher hosts. His topic is backups, and while I’m sure there will be plenty of views on backups, I wanted to touch base on a relatively simple item. This is the monthly … Continue reading

Posted in Uncategorized | Tagged , , | 1 Comment

A New Recovery Tool for Your Toolbelt

Those of us that administer databases and are responsible for ensuring the integrity and availability of data know that being able to restore systems is a core skill. In the SQL Server world, this should mean more than just being able to … Continue reading

Posted in Editorial | Tagged , , ,

The Google Solution

I was watching a talk from Google on how they back up their data. After all, one of the biggest assets Google has is the tremendous amount of data that they have collected over the years. There are many systems … Continue reading

Posted in Editorial | Tagged

What’s Your Backup Speed?

I ran across a thread recently where someone was looking to estimate the time it too to perform a 600GB backup. I’ve seen other threads with similar questions. The general advice is that you need to run a backup and … Continue reading

Posted in Editorial | Tagged , , | 1 Comment

Backups Over Time

I’ve written about backups at various times, including responsibility, problems with systems, and home protection. This is a subject that is important to me, as I consider the responsibility for protecting data to be first and foremost. Security, performance and … Continue reading

Posted in Editorial | Tagged

Converting SQL Backup Files to MTF

I got a copy of some backup files recently and needed to restore them. However, I don’t have SQL Backup installed on all my instances. It’s not a big deal to install it, but since this is a one-off, I … Continue reading

Posted in Blog | Tagged , , , ,

Restoring a Striped Backup–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I uncompressed some SQL Backup Pro files. Since multiple threads were used to make the backup, I ended … Continue reading

Posted in Blog | Tagged , , , , | 2 Comments

The Writeable Warm Standby

I saw a question recently that went like this: I get one full backup from FTP. I’ll get daily log backups through FTP after this, but never another full. I need to restore this daily log backup and allow the … Continue reading

Posted in Blog | Tagged , , ,

The Log Chain

I ran across a question recently from someone that received a similar message to the one showed in this image: In this case, the log chain is broken. I’ve received this message, usually from a script that is automatically restoring … Continue reading

Posted in Blog | Tagged , , ,