Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Mirroring cannot be restarted after stop

hello  As below pic shown, after I stop the replication. The 'Start replication' button is set to unavailable.   But somehow I remember that last week I am able to restart the replication after I ...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
2 years ago

hello,

I am trying to mirror data from Azure SQL database. The function was working well during in the past. Recently I stopped the repilication since I want to config the replication. I click the Configure replication buttion of mirroring interface as below pic. and I choose some of the tables, and unclick some of the tables, then click Apply Changes button.

 

So I see the screen like below:

It shows me 'Mirrored Azure SQL Database is stopping.'

and buttons of Start replication, stop replication, and monitor replication is set to unavailable.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 
Can you try to create a new mirrored database going to this same source? If it says the SQLDB is already Mirrored, run this on the source sql db:
EXEC sys.sp_change_feed_disable_db
Try this and let me know.
Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I created a new mirrored database with same data source. And it successfully created. And I can monitor the status like below:

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous 
        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
        Thanks