SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Mirroring Problems


Database Mirroring Problems

Author
Message
Laerte Poltronieri...
Laerte Poltronieri Junior-367636
SSC Eights!
SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)

Group: General Forum Members
Points: 903 Visits: 836
Hi all..

I have 2 server in mirroing... this morning i have to boot the mirror server and whens its up the message in mirror database was "restoring..." only.Before the message was something like (restoring, synchronized..etc)..now only "restoring..." . In principal server the message is "principal, synchronized"..but will be synchronized really ?

When i configured this mirroring , this message in target server (only "restoring...") shows up when i restored the dabatase before starts synchronized doing de statments ALTER DATABASE XXX SET PARTNER in principal an target servers.

I try to do this statments agains and shows up a error message

Principal
Msg 1405, Level 16, State 4, Line 1
The database "SM" is already enabled for database mirroring.

Target
Msg 1452, Level 16, State 6, Line 2
The partner server instance name must be distinct from the server instance that manages the database. The ALTER DATABASE SET PARTNER command failed.


This servers are really synchronized ?

$hell your Experience !!!
MANU-J.
MANU-J.
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 6986 Visits: 8766
Check the output of
select * from sys.database_mirroring on principal database and verify whether the configuration is fine and mirroring state is synchronized or Synchronizing.

You can also make use of database mirroring monitor and check the same(by registering your mirroring instances and see whether trafic is there when principal is getting updated).

HTH,
MJ
Laerte Poltronieri...
Laerte Poltronieri Junior-367636
SSC Eights!
SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)

Group: General Forum Members
Points: 903 Visits: 836
Thanks Manu...the select returns in columns

mirroring_state mirroring_state_desc
4 SYNCHRONIZED

for all databases with mirroring

can I presume that everything okay?

$hell your Experience !!!
MANU-J.
MANU-J.
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 6986 Visits: 8766
Yes, you can presume that. Also, you can do one thing(if possible) to check this out:

Do a failover when its okie and nobody will get affected. If it goes to mirrored database then it will confirm you to the fullest extent tht all is working fine under the hood.

Manu
Laerte Poltronieri...
Laerte Poltronieri Junior-367636
SSC Eights!
SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)SSC Eights! (903 reputation)

Group: General Forum Members
Points: 903 Visits: 836
Thanks a lot Manu...

$hell your Experience !!!
pearsonrken
pearsonrken
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 8
I just spent 2 days trying to figure this out and I got it.

On th Mirror reference the Primary server.

ALTER DATABASE MYDB_04

SET PATNER = 'TCP://PRINCPLESERVERNAME.DOMAIN.LOCALTongueORT#'

On the Primary reference the Mirror server.

ALTER DATABASE MYDB_04

SET PATNER = 'TCP://MIRRORSERVERNAME.DOMAIN.LOCALTongueORT#'

This is not stated correctly in the documentation the I have read.

K9
TheSQLGuru
TheSQLGuru
SSC-Dedicated
SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)

Group: General Forum Members
Points: 30831 Visits: 8668
Everyone PLEASE understand that database mirroring is an ADVANCED topic and you REALLY need to study up and practice with it in a test environment before pursuing it. Even better would be to engage a qualified consultant to help you a) understand what you HA/DR needs truly are and b) ensure you get there effectively and c) know how to troubleshoot/resolve issues that might crop up. You might just have your businesses very existence on the line here.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
mike.mcquillan
mike.mcquillan
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1681 Visits: 458
Hi Laerte

It does sound as though your mirroring configuration is fine. Daft as it sounds, try doing a refresh of the tables in SSMS. This will probably fix the issue regarding not seeing "restoring, synchronized" against each database.

For what it's worth, Kevin is absolutely spot on - mirroring is definitely an advanced topic. I played about in a test environment quite a bit, doing automatic failovers/manual failovers, turning servers off etc to see what would happen. It is not something I would recommend anybody should put into production until you are comfortable you can manage it correctly.

Mike.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search