Database Mirroring not synching till I open Mirroring Monitor

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dba - 25 Nov 2008 19:54 GMT

Hello All,

I'm rather new to mirroring, I had to setup the princible and the
mirror using certificates per the example in BOL. I am using
asychronous mode. Everything looks good till I launch the Database
Mirroring Monitor. In the left hand side it will say Time to Send Log
under Princible. This duration will always be equal to the last time
since I opened DMM. When I look at the history for the two this is
confirmed, the Princible writes continuously new transactions. As
where the mirror, even if I say show me everything for the last day.
It will only show me records corresponding to the times I've had DMM
open.
My question is how can I view messages in the queue on the
princible, and what kicks off the sending of this data to the mirror,
also how can I test connectivity between the two.

Thank you in Advance!

Reply to this Message

Mohit K. Gupta - 26 Nov 2008 01:02 GMT

In database mirroring, it continously sends transaction to the other server.
Once the end-points are established, and mirroring is set the information
follows on without user interaction.

Asychronous mode makes it so the SQL Server is not waiting for a response
from mirror partner to confirm everything was fine. It confirms everything
is good and leaves the transaction to be set on its own time.

For it not to send it might have had network communication error; once a
network communication error occures and the mirror principle determines that
the mirror partner is no longer avalaible it will hold the longs until the
mirroring is resumed. You can set up notification services to fire you an
email when the communication is borken between the two servers.

As for the logs I will check into that, I don't belive there is a setting; I
don't remeber top of my head.

Signature

Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

> Hello All,
>
[quoted text clipped - 13 lines]
>
> Thank you in Advance!

Reply to this Message

dba - 26 Nov 2008 19:09 GMT

Getting some strange AD errors:

Event Viewer => Application:

Event Type: Warning

Event Source: Userenv

Event Category: None

Event ID: 1109

Date: 11/26/2008

Time: 1:36:27 PM

User: NT AUTHORITY\SYSTEM

Computer: DATABASE_SERVER

Description:

CN=SASQL,OU=No Policy System Accounts,DC=PDE,DC=com from a different
forest logged onto this machine. Cross Forest Group Policy processing
is disabled and loopback processing has been enforced in this forest
for this user account.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Event View => System:

Event Type: Information

Event Source: DnsApi

Event Category: None

Event ID: 11162

Date: 11/26/2008

Time: 8:59:20 AM

User: N/A

Computer: DATABASE_SERVER

Description:

The system failed to register host (A) resource records (RRs) for
network adapter

with settings:

Adapter Name : {5CA0F830-2AD9-4AE8-A38D-32088F3F5233}

Host Name : DATABASE_SERVER

Primary Domain Suffix : douglaselliman.com

DNS server list :

172.16.1.36, 172.16.1.5

Sent update to server : 172.16.1.36

IP Address(es) :

172.16.1.174

The reason the system could not register these RRs was because the
update request it sent to the DNS server timed out. The most likely
cause of this is that the DNS server authoritative for the name it was
attempting to register or update is not running at this time.

You can manually retry DNS registration of the network adapter and
its settings by typing "ipconfig /registerdns" at the command prompt.
If problems still persist, contact your DNS server or network systems
administrator.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Data:

0000: 2c 23 00 00 ,#..

Reply to this Message

Mohit K. Gupta - 26 Nov 2008 19:30 GMT

DNS Issues?

Hmm when creating end points and setting the mirroring between the two
servers; try using the IP:Port combination instead of Server:Port
combination. To elminate the DNS out of the issue.

Also you said you are using the Certificate to do authenication; so
cross-domain authenication should not be an issue.

Thanks.

Signature

Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

> Getting some strange AD errors:
>
[quoted text clipped - 83 lines]
>
> 0000: 2c 23 00 00 ,#..

Reply to this Message

dba - 01 Dec 2008 19:06 GMT

I'm wondering how do you setup a Service Princible Name for database
mirroring endpoints? For SQL Server itself it's just:
setspn -A MSSQLSvc/myserver.microsoft.com:1433 MYDOMAIN\sqlsvc

I'm guessing it would look something like:

setspn -A MSSQLSvc/myserver.microsoft.com:1544 MYDOMAIN\sqlsvc

but is the service name going to be the same?

Reply to this Message

Mohit K. Gupta - 01 Dec 2008 19:19 GMT

As far as I know that is not possible, i.e. configuring SPN for the
End-points. I have yet to use that, or look at it.

I did look around on other newgroups, and such but no answer :(. Sorry.

Signature

Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

> I'm wondering how do you setup a Service Princible Name for database
> mirroring endpoints? For SQL Server itself it's just:
[quoted text clipped - 5 lines]
>
> but is the service name going to be the same?

Reply to this Message