how do you ship logs through dedicated NIC?

• Sl33py

  Mr or Mrs. 500

  Points: 532

  More actions

  October 16, 2013 at 1:44 am

  #299196

  Hi All

  I have read through the post on the below link :

  http://blogs.msdn.com/b/sqlserverfaq/archive/2010/03/31/step-by-step-guide-to-setup-a-dedicated-sql-database-mirroring-dbm-on-dedicated-nic-card.aspx

  I am now wondering if I would do the same for log shipping to a DR server?

  active server with 2 NICs

  nic1 day to day functions 172.20.20.18

  nic2 dedicated to log shipping 172.21.20.19

  DR server same setup

  nic1 day to day functions 172.20.20.21

  nic2 dedicated to log shipping 172.21.20.30

  would this be done with T-SQL or just the same as in the above link?

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  October 16, 2013 at 7:33 am

  #1658880

  when configuring the secondary and you specify the primary server\instance specify the dedicated NIC IP

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉

• Sl33py

  Mr or Mrs. 500

  Points: 532

  More actions

  October 16, 2013 at 7:36 am

  #1658885

  Thank you very much!