Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Log shipping configuration Expand / Collapse
Author
Message
Posted Friday, March 15, 2013 1:00 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
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
Post #1431377
Posted Friday, March 15, 2013 2:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 14, 2013 8:05 AM
Points: 101, Visits: 108
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
Post #1431399
Posted Friday, March 15, 2013 2:59 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Thanks Ram...

Pradeep
Post #1431411
Posted Saturday, March 16, 2013 7:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:55 AM
Points: 6,194, Visits: 13,349
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"
Post #1431895
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse