Post reply

Change to Restore with No recovery

  • August 11, 2016 at 8:05 am

    #312426

    HI,

    Is there any way to change an already restored DB to 'Restore with No Recovery'

    without re-running a restore?

    Long story but I need to re-establish an A/G connection from a LUN Snap.

  • August 11, 2016 at 10:15 am

    #1895050

    Short answer: No.

    Long answer: When you go through recovery, you apply roll forward and rollback. There's no mechanism to undo these things. A Standby file allows tracking of these items for querying, but the functionality in SQL isn't there for doing this after you've recovered.

  • August 11, 2016 at 10:32 am

    #1895056

    Kinda figured, but was hoping for something.

    Thanks Steve.

  • August 11, 2016 at 11:26 am

    #1895068

    Sorry, I've wanted this as well. If no new log records, why not?

    Not a priority for MS. 🙁

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply