2

Does MSSQL support an operating mode on the failover partner / mirror that is functionally equivalent to Oracle database's Snapshot Standby mode?

ie A temporary active copy of the replicated database that can be open for read/write but can be reverted back to a replication target without rebuild?

1
  • 1
    I think Merge Replication is the closest thing, only because it satisfies being writable. However, I wouldn't recommend anyone implement it unless they're being punished for something egregious. Commented Jul 31, 2018 at 20:33

1 Answer 1

1

Mirroring does NOT have this capability. If you are using the Enterprise Edition of SQL Server then an Availability Group (MSSQL's successor to mirroring) with a readable secondary would do this, but you would be required to license both instances with EE licenses.

1
  • 1
    I believe they're looking for read/write. Commented Jul 31, 2018 at 21:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.