locked
Mirroring across networks RRS feed

  • Question

  • Is it possible to mirrir across 2 IP ranges?

    I have a SQL Server sitting on a 192.168.11 network. Is it possible to mirror a database to a corresponding SQL Server on a 192.168.10 network?

    Monday, January 14, 2013 3:16 PM

Answers

All replies

  • Are the servers on same domain?? If they are, you can do it. If not , you need to create mirroring certificate. Please refer http://technet.microsoft.com/en-us/library/ms191140(v=sql.100).aspx .

    Also refer http://social.msdn.microsoft.com/Forums/en/sqldatabasemirroring/thread/e2363a0b-913c-409f-b84e-c4d977044785

    http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/dc49181c-bd0d-44ab-ab3b-70e454e66ee5

    Besides, make sure your mirroring ports are not being blocked by the firewalls


    Please mark as 'Answer', if the solution solves your problem.


    • Edited by Stan210 Monday, January 14, 2013 5:24 PM
    • Proposed as answer by PrinceLucifer Tuesday, January 15, 2013 6:24 AM
    • Marked as answer by Allen Li - MSFT Monday, January 21, 2013 5:55 AM
    Monday, January 14, 2013 5:24 PM
  • Stan already said it, just to bring it right to the point: Yes, it is possible. The network segment has no impact whatsoever on mirroring
    Tuesday, January 15, 2013 6:24 AM
  • Thanks guys.

    Also, is it necessary to have an instance of SQL Server running for the mirror?

    What I plan on doing is mirroring a database from a SQL server on my production SAN to my DR SAN. I'm not sure if I need to create a SQL Server volume similar to my live one(ie SQL server 2005 sitting on Windows 2003 server) or if I can just mirror to a .mdf/.ldf on my DR SAN?

    Thursday, January 24, 2013 8:46 AM
  • Yes, your second instance would require SQL Volume. The way you do it is..take Full backup of the production database and restore on secondary site "with no recovery" and then take a log backup and restore it on secondary in "no recovery " and configure your mirroring.so, to answer your question, yes, you need a secondary database on Secondary instance but it will be in restoring state(not accessible) .Only during failover, secondary instance becomes primary(Principal) and Current prinicipal would be secondary(mirrioring,restoring state).

    Hope it Helps!!

    Thursday, January 24, 2013 6:04 PM