?
Solved

Microsoft SQL Log shipping on 2005

Posted on 2014-03-01
1
Medium Priority
?
213 Views
Last Modified: 2014-04-21
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
Comment
Question by:HitenderPotan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 39900632
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question