Log shipping configuration

  • 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

  • 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

  • Thanks Ram...

    Pradeep

  • 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