• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

Microsoft SQL Log shipping on 2005

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.
0
HitenderPotan
Asked:
HitenderPotan
1 Solution
 
lcohanDatabase AnalystCommented:
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.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now