Database Mirroring Question

SQL Server Administration
1

Hi experts,
First, I realize that db mirroring is an older technology that has been replaced by AlwaysOn.

But I'm demonstrating mirroring and a question came up. Our setup includes only 2 servers, no witness.
I failed over to the mirror by running .... Set Partner Failover.
But if the principal/primary went down unexpectedly, how would I make the mirror database usable - get it our of 'Restoring' mode yet preserver the mirroring so that when the Primary came up, I could fail back to it. Hope this makes sense. Thanks

2

You'd have to use the FORCE_SERVICE_ALLOW_DATA_LOSS option on the secondary, details are here:

1 Like