Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Helpful Advice?

By Steve Jones,

This editorial was originally published on Feb 5, 2007 and is being re-run as Steve is on vacation.

I have to be honest with you. It wasn't me. This advice on DR wasn't given to anyone by me. This post is from a blog entry last year before Tech Ed. I made a note of it, but it wasn't until recently I got around to actually writing about it.

I'm kind of surprised to see some of this advice being given to people. Some of these I don't think are too bad, but would you do any of these on your production database?

  1. "Just run REPAIR_ALLOW_DATA_LOSS and you'll be fine..."
  2. Just rebuild your transaction log using these steps..."
  3. "Just restore your database and carry on..."
  4. "Run CHECKALLOC, then CHECKDB, then CHECKTABLE on all your tables, then..."
  5. "Just flick the power switch on and off a few times on one of the drives..."

Actually I've done #4 and #3 is something I've had to do before as well. I can appreciate the caution in the article about not finding the root cause, but I've had more problems than I'd like to think about where we couldn't find a root cause in a reasonable time and decided to move on. And we never had the issue again. In the interests of getting the business going, there was a time where I explained everything, guesstimated the data loss, and we decided to just restore, lose the data, and have people re-enter it as quickly as possible.

As for the other items, I don't think I'd run REPAIR_ALLOW_DATA_LOSS without someone from CSS on the phone. And I don't think I've ever even heard about anyone "rebuilding" a transaction log. That sounds like one of those urban myths where someone heard that someone said that they had a way to rebuild a log.<

Flicking the power on your drives? I'm not sure what I'd even say to someone who suggested it.

Total article views: 110 | Views in the last 30 days: 1
Related Articles

Rebuild Index

Rebuild Index


Thinking Time

It's important to have time to think, but quite often we don't find the time. Steve Jones comments o...


Have a Think

It's easy for most of us to get caught up in work and not stop to think about the larger picture, or...


Rebuilding indexes

Rebuilding indexes


Rebuild Index

Rebuild does not defrag the indexes.


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones