If you resume mirroring for this database, and if transactions are committed at '{0}' but the log was not sent to the former ...

If you resume mirroring for this database, and if transactions are committed at '{0}' but the log was not sent to the former mirror server instance, the transactions are rolled back. This situation can occur after the following sequence of events:

(1) The connection between the principal and mirror server instances is lost.

(2) The principal continues to commit transactions locally but cannot send the log records to the mirror.

(3) A FORCE_SERVICE_ALLOW_DATA_LOSS command forces service to the mirror database, which assumes the principal role.

(4) The connection between the partners is reestablished, the original principal server assumes the mirror role, and mirroring is suspended.


Do you want to resume mirroring and roll back any transactions committed at server instance '{0}' but not sent to server instance '{1}'?

If you answer "Yes," any transactions whose log is unsent will be lost. If you answer "No," you can remove mirroring and bring the database at '{0}' online, to help you identify those transactions.

If you plan to change the snapshot properties, do not start the Snapshot Agent until after you change the properties in the ... If you proceed with upgrade, SQL Server Setup will move the SQL Server resource group {0}' from the current node to a node ... If you proceed with upgrade, SQL Server Setup will move the SQL Server resource group {0}' to a node that has already been ... If you remove this server instance, Database Mirroring Monitor will not be able to fully monitor the databases for which ... If you resume mirroring for this database, and if transactions are committed at '{0}' but the log was not sent to the former ... If you save the view encrypted, you will no longer be able to alter the view definition. Do you want to save the view encrypted? ... If you select a non-key granularity attribute, the server will not be able to aggregate data properly unless you make sure ... If you select Yes, the replicated data remains on the Publisher and Subscribers; however, the data loses its synchronization ... If you want to change the current settings and disallow the creation of temporary mining models, clear the checkbox below. ...