Database Mirroring not synching till I open Mirroring Monitor

25 Nov 2008 7:54 PM

dba

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!

26 Nov 2008 1:02 AM

Mohit K. Gupta

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.

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

Show quoteHide quote

"dba" wrote:

> 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!
>

26 Nov 2008 7:09 PM

dba

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               ,#..

26 Nov 2008 7:30 PM

Mohit K. Gupta

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.

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

Show quoteHide quote

"dba" wrote:

> 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               ,#..
>
>

1 Dec 2008 7:06 PM

dba

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?

1 Dec 2008 7:19 PM

Mohit K. Gupta

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.

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

Show quoteHide quote

"dba" wrote:

> 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?
>
>
>
>