import backup from database miroring to ALWAYSON

• abdalah.mehdoini

  Ten Centuries

  Points: 1028

  More actions

  May 5, 2019 at 11:20 pm

  #3636127

  Good evening everyone

  I have a backup of a database configured in mirroirng

  I have to use this backup for the imported in an alwayson configuration

  Should you remove the mirroring on this base and make another backup before importing it into the alawayson

  thank you for your advice

• Eddie Wuerch

  SSChampion

  Points: 12541

  More actions

  May 6, 2019 at 6:36 pm

  #3636598

  A database backup carries no details about any mirroring or AG configuration.

  Leave your current mirroring in place. Any backup you take (or have already taken) of a mirrored database may be restored as a stand-alone database from which an AG may be created.

  Eddie Wuerch
  MCM: SQL