Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

parjj

Azure SQL db mirroring stops when capacity is paused

Submitted by on ‎05-22-2024 01:24 AM

It seems that the mirroring stops when Fabric capacity is paused and it does not continue after capacity resumes. It shows as working when looking at the "monitor replication".  

Can it be made so that the replication would continue automatically?

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎05-23-2024 01:31 AM

Hi  @parjj ,

 

When a session is paused, the principal database remains available. Pausing sets the state of the mirroring session to SUSPENDED, and the mirror database no longer keeps up with the principal database, causing the principal database to run exposed.

 

For this feature you may refer to Pause & resume database mirror - SQL Server Database Mirroring | Microsoft Learn

 

Best regards.
Community Support Team_Caitlyn

 

Idea Statuses