<div>
The principal says synchronized, but the mirror says disconnected? Doesn't seem right.<br />
<br />
Do you have multiple SQL instances on the mirror server?<br />
<br />
Rob
</div>


The principal says synchronized, but the mirror says disconnected? Doesn't seem right.

Do you have multiple SQL instances on the mirror server?

Rob

<div>
The two servers must be talking a bit, because the principal thinks they're synchronized. But it definitely seems strange that the mirror doesn't think so.<br />
<br />
If you turn the mirror off (stop the service perhaps), does the principal realise and change its status?<br />
<br />
Rob<br />

</div>


The two servers must be talking a bit, because the principal thinks they're synchronized. But it definitely seems strange that the mirror doesn't think so.

If you turn the mirror off (stop the service perhaps), does the principal realise and change its status?

Rob


<div>
<div class="content wysiwyg-content">
Hi Folks,<br />
<br />
I have SQL 2005 mirroring happening<br />
<br />
the mirroring state + current role of my databases in database mirroring monitor for the mirror says not connected, the principal says synchronized. I actually failed over a database to check if it has recent data transferred &nbsp;and it seems it does. To setup mirroring I needed to so this via T-SQL rather than the mirroring wizard as the wizard could not see the partner I was connecting to. On the mirror in db mirror monitor it is also saying not connected. The partner are on different networks through a firewall - which seems to not be the problem because the failover seems to be ok. What is going on?<br />
<br />
&nbsp;
</div>
</div>


Hi Folks,

I have SQL 2005 mirroring happening

the mirroring state + current role of my databases in database mirroring monitor for the mirror says not connected, the principal says synchronized. I actually failed over a database to check if it has recent data transferred  and it seems it does. To setup mirroring I needed to so this via T-SQL rather than the mirroring wizard as the wizard could not see the partner I was connecting to. On the mirror in db mirror monitor it is also saying not connected. The partner are on different networks through a firewall - which seems to not be the problem because the failover seems to be ok. What is going on?

 

Database mirroring monitor mirroring state

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.