Microsoft SQL Log shipping on 2005

HitenderPotan
HitenderPotan used Ask the Experts™
on
Dear Team,


 I  had configured Sql log shipping on sql server 2005. my secondary Sql server is in different branch  and both site we have MPLS connectivity., now just 2 days back my MPLS connectivity down due to some issue with network. i have already another aitel line. so i want to put my new ip address. please let us know how we can do this activity and what was the impact.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
In my opinion the best thing to do would be to stop Log Shipping, disable it on Primary and then re-do it from scratch on the new destination(Secondary) starting from Full backup/restore.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial