Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Mirroring in SQL 2008 R2 instanct Expand / Collapse
Author
Message
Posted Friday, April 19, 2013 2:43 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 12, 2014 8:19 AM
Points: 20, Visits: 254
I believe this error is related to database mirrroring. I have more than 90+ databases configured DB mirroring on a single instance and everything seems to work fine.. This below error seems to appear in the sql server error log in the mirrored server.

The server instance Partner rejected configure request; read its error log file for more information. The reason 1460, and state 1, can be of use for diagnostics by Microsoft. This is a transient error hence retrying the request is likely to succeed. Correct the cause if any and retry.


Any help is appreciated!
Post #1444615
Posted Tuesday, April 23, 2013 11:36 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:47 AM
Points: 839, Visits: 1,198
Check the below link...
http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/58a1ddf1-90f5-4528-916d-5beb820700dd/
Post #1445602
Posted Tuesday, April 23, 2013 11:58 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:16 AM
Points: 20,860, Visits: 32,884
DevDB (4/23/2013)
Check the below link...
http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/58a1ddf1-90f5-4528-916d-5beb820700dd/


Make it easier for others:

http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/58a1ddf1-90f5-4528-916d-5beb820700dd/



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1445612
Posted Wednesday, April 24, 2013 9:39 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:47 AM
Points: 839, Visits: 1,198
Thanks Lynn. Learned how to do this and will keep that in mind form next time.
Post #1446069
Posted Wednesday, April 24, 2013 10:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 12, 2014 8:19 AM
Points: 20, Visits: 254
Thanks for the response.. But in my case, database mirroring for 101 databases is working fine :).. I even did a failover, everything seems to be okay. I am not using TDE as mentioned in the article.

I am only seeing the error msg on mirrored server.

The server instance Partner rejected configure request; read its error log file for more information. The reason 1460, and state 1, can be of use for diagnostics by Microsoft. This is a transient error hence retrying the request is likely to succeed. Correct the cause if any and retry.


Post #1446105
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse