Post reply

Database Mirror

  • March 10, 2011 at 8:02 am

    #147427

    Hi All, I trying configurate Database Mirroring with my SQL Server 2005 Enterprise Edition SP3, and I wonder if this version of SQL Server I can I set the mirror to use a dedicated NIC.

    For example in SQL Server 2008 I know that if you can set up two NICs, one for normal work operations and one for the mirror. SQL Server 2005 Enterprise Edition sp3 I can set it too?

  • March 10, 2011 at 9:25 am

    #1297171

    is your mirror on a different network segment? i think you can use the route add command to create a static route.

  • March 11, 2011 at 6:17 am

    #1297573

    Yes, you can do this.

    CREATE ENDPOINT [mirroring]

    ....AS TCP (LISTENER_PORT = 5022, LISTENER_IP = (XX.XX.XX.XX))....

    This is a good idea for 2 reasons: 1. Mirroring traffic does not compete for bandwidth on the production NIC. 2. If you are long distance async mirroring, your WAN team may want to route that traffic over a specific WAN connection.

    See http://msdn.microsoft.com/en-us/library/ms181591.aspx for more details on the Create Endpoint syntax

    Thanks, Craig

  • March 11, 2011 at 11:29 am

    #1297820

    Thanks a Million Man!...

    Thankyou again...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply