Browse by Tags

• DBCC
• Disaster Recovery
• Restore
• VLDB Maintenance

• When is too much success a bad thing?

  I was talking to a customer the other day who had an interesting problem: Successful backups. Specifically, their problem had to do with the success messages that SQL backup puts in the SQL errorlog and the system event log. Seems like a nice, friendly Read More... Posted Tuesday, October 30, 2007 9:18 AM by kfarlee | 4 Comments Filed under: Disaster Recovery, Backup

• Fuzzy backups and RESTORE DATABASE WITH STOPAT

  So what’s a “fuzzy backup” and how does it relate to STOPAT? There has been some confusion about what RESTORE DATABASE WITH STOPAT does, if it works, and why it behaves as it does. This is not about RESTORE LOG WITH STOPAT, but only RESTORE DATABASE. Read More... Posted Friday, October 26, 2007 3:25 PM by kfarlee | 1 Comments Filed under: Disaster Recovery, Backup, Restore

• The Ins and Outs of Offline Files

  First blog post of the year from TechEd! Well, Kimberly and I arrived a day early hoping to chill out in the sun by the pool but contrary to all expectations the weather sucks today – it’s actually much better in Seattle. Instead we're hibernating in Read More... Posted Saturday, June 02, 2007 12:35 PM by Paul Randal - MSFT | 1 Comments Filed under: Disaster Recovery, Backup, Restore Attachment(s): offlinefile.sql

• Can you mix-n-match backup devices?

  I was asked this question yesterday and didn't know the answer so thought it would be good for a quick post. Can you use devices from your main and mirrored backup media sets together to perform a restore? The code below creates a single-device backup Read More... Posted Sunday, April 22, 2007 5:15 PM by Paul Randal - MSFT | 1 Comments Filed under: Backup, Restore, VLDB Maintenance

• Oh no – my backup is corrupt too! Help!

  Funny how a bunch of people all seem to have the same problem at the same time. Maybe it’s just that people don’t want to talk about corruption until someone else does – it’s like a dark secret that once let out of the bag – everyone talks. The common Read More... Posted Monday, March 05, 2007 1:59 PM by Paul Randal - MSFT | 2 Comments Filed under: DBCC, Disaster Recovery, Backup, Restore

• What Master???

  I've come across a few interesting DR scenarios lately, (interesting in the sense that the resolution wasn't immediately obvious, and fortunately the answer didn't start out with "update your resume...") The situation that comes to mind is a customer Read More... Posted Tuesday, September 26, 2006 10:18 AM by kfarlee | 6 Comments Filed under: Disaster Recovery, Backup, Restore

• Why you should NOT optimize your backup strategy for backup speed

  Sounds kinda funny, doesn't it? I mean, who here doesn't have someone breathing down your neck every time you go past your backup window? So why would you NOT optimize for fast backups? It just makes sense. You do backups every day, so they should be Read More... Posted Monday, June 19, 2006 9:50 PM by kfarlee | 3 Comments Filed under: Disaster Recovery, Backup, Restore

• Just why are you backing up your database?

  So, I'd like to make a couple of assertions about backup and disaster recovery that will hopefully get you to thinking, and just might change the way you think about the topic. There are two distinct motivations for doing backups, and they imply differing Read More... Posted Thursday, June 15, 2006 3:35 PM by kfarlee | 2 Comments Filed under: Disaster Recovery, Backup