locked
Mirroring + Replication - Pause mirroring stop replication RRS feed

  • Question

  • http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/afbe5236-8627-41f9-b579-3bd2b6e96b49/

    I have the same issue. I just wonder if I change mirroring from high safety to high performance, and it can fix the issue?

    Thanks

    David

    Tuesday, March 26, 2013 11:19 PM

Answers

  • Hi David,

    Keep the following issues in mind if database mirroring is removed from a published database:

    •If the publication database at the principal is no longer mirrored, replication continues to work unchanged against the original principal.

    •If the publication database fails over from the principal to the mirror and the mirroring relationship is subsequently disabled or removed, replication agents will not function against the mirror. If the principal is permanently lost, disable and then reconfigure replication with the mirror specified as the Publisher.

    •If database mirroring is removed completely, the mirror database is in a recovery state and must be restored in order to become functional. The behavior of the recovered database with respect to replication depends on whether the KEEP_REPLICATION option is specified. This option forces the restore operation to preserve replication settings when restoring a published database to a server other than that on which the backup was created. Use the KEEP_REPLICATION option only when the other publication database is unavailable. The option is not supported if the other publication database is still intact and replicating.

    For more information, please refer to Database Mirroring and Replication (SQL Server): http://msdn.microsoft.com/en-us/library/ms151799.aspx.

    If you have any feedback on our support, please click here.

    Thanks.

     


    Maggie Luo
    TechNet Community Support

    • Marked as answer by Maggie Luo Sunday, April 7, 2013 3:45 PM
    Wednesday, April 3, 2013 10:23 AM

All replies

  • did some tests. Changed mirroring to high performance, pause mirroring, replication was stopped as well. 

    So it means if we pause mirroring, replication will be paused, does not matter which kind of mirroring setting. 

    How can we avoid the issue? 

    Thanks

    Wednesday, March 27, 2013 1:21 AM
  • You need to enable trace flag 1448 http://msdn.microsoft.com/en-us/library/ms188396.aspx

    Tuesday, April 2, 2013 9:00 PM
  • Hi David,

    Keep the following issues in mind if database mirroring is removed from a published database:

    •If the publication database at the principal is no longer mirrored, replication continues to work unchanged against the original principal.

    •If the publication database fails over from the principal to the mirror and the mirroring relationship is subsequently disabled or removed, replication agents will not function against the mirror. If the principal is permanently lost, disable and then reconfigure replication with the mirror specified as the Publisher.

    •If database mirroring is removed completely, the mirror database is in a recovery state and must be restored in order to become functional. The behavior of the recovered database with respect to replication depends on whether the KEEP_REPLICATION option is specified. This option forces the restore operation to preserve replication settings when restoring a published database to a server other than that on which the backup was created. Use the KEEP_REPLICATION option only when the other publication database is unavailable. The option is not supported if the other publication database is still intact and replicating.

    For more information, please refer to Database Mirroring and Replication (SQL Server): http://msdn.microsoft.com/en-us/library/ms151799.aspx.

    If you have any feedback on our support, please click here.

    Thanks.

     


    Maggie Luo
    TechNet Community Support

    • Marked as answer by Maggie Luo Sunday, April 7, 2013 3:45 PM
    Wednesday, April 3, 2013 10:23 AM
  • Hi David,

    I’m writing to follow up with you on this post. Was the problem resolved?

    If you are satisfied with our solution, I’d like to mark this issue as "Answered". Please also feel free to unmark the issue, with any new findings or concerns you may have.   

    Thanks.
     

    Maggie Luo
    TechNet Community Support

    Sunday, April 7, 2013 3:46 PM