Post reply

Restore database in AlwaysON

  • February 2, 2018 at 4:45 am

    #410191

    Good afternoon.
    Tell me how to restore the database to a specific point in time, if she is in an AlwaysON availability group SQL Server 2016? Just the user has entered incorrect data. Use synchronous-commit mode, transaction on the secondary replica. Thank you in advance.

  • February 2, 2018 at 4:51 am

    #1978324

    You have to remove the database from the Availability Group, perform the restore in the usual way, and then put it back into the AG.

  • February 2, 2018 at 4:57 am

    #1978325

    Beatrix Kiddo - Friday, February 2, 2018 4:51 AM

    You have to remove the database from the Availability Group, perform the restore in the usual way, and then put it back into the AG.

    this is the only way?

  • February 2, 2018 at 4:59 am

    #1978326

    Yes.

  • February 2, 2018 at 5:03 am

    #1978327

    Beatrix Kiddo - Friday, February 2, 2018 4:59 AM

    Yes.

    thanks again 🙂

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

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