• You mean you don't just automatically do all of those things every day?

    I have a job that runs them automatically every day, right in the middle of peak business hours, when our websites and databases are under maximum load. That insures the best results!

    Especially the bit about repeatedly cycling the power on the SAN. That's critical!

    ...

    Meanwhile, back in reality, I've had to restore a database and move on, but that was before I actually knew about point-in-time options on DR.

    I once had to take a database offline and rebuild a copy of it from backups, but I brought it up to present-time without any data loss. That was to handle a locked SPID that just simply would not finish rolling back a non-existent transaction, which was blocking a few database level operations that were needed.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon