0

I'm trying to perfect our disaster recovery steps...

We take backups of a database that, in production, is in an AG. It is the only database in the AG.

If we lose the building, I need to be able to restore it to a new instance. Initially, for time's sake, this instance would not be running in an AG.

Of course, if you try a normal restore, you get error Msg 3104: "RESTORE cannot operate on database 'SI_EDI_PRD' because it is configured for database mirroring or has joined an availability group."

And, since the instance is not configured for AlwaysOn, you can't try to run the ALTER AVAILABILITY GROUP command.

How can one restore this database??

Johnboy
  • 43
  • 5

1 Answers1

1

Looks like Brent answered it in a thread I hadn't seen: SQL Availability Group restore database to standalone server

Short answer: Don't restore the master database of an AG.

I'm not happy with this....But it'll do.

Thanks, everyone!

Community
  • 1
Johnboy
  • 43
  • 5