Post reply

Log shipping configuration

  • March 15, 2013 at 1:00 am

    #272252

    Hi,

    I configured log shipping based on server host name in both production and DR server and its working fine. Now our company decided to change server IP's for both production and DR servers.

    My doubt is if will change server IP's existing log shipping configuration will affect?

    Kindly advice me on this for further process.

    Thanks.

    Pradeep

  • March 15, 2013 at 2:16 am

    #1597379

    Yes it does effect logshipping. To avoid this add both ip's in dns entry to point at sql server and run the ipconfig /flushdns after adding them in dns.

    Thanks

    Regards,

    Ram

  • March 15, 2013 at 2:59 am

    #1597389

    Thanks Ram...

    Pradeep

  • March 16, 2013 at 7:42 am

    #1597810

    pradeep.mohan (3/15/2013)

    Hi,

    I configured log shipping based on server host name in both production and DR server and its working fine. Now our company decided to change server IP's for both production and DR servers.

    My doubt is if will change server IP's existing log shipping configuration will affect?

    Kindly advice me on this for further process.

    Thanks.

    Provided you havent used the server IP address during the log shipping configuration then it should be fine. When you change the IP the DNS records should be updated. When restarted, sql server will listen on the new IP address.

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

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

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

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