Solved

Microsoft SQL Log shipping on 2005

Posted on 2014-03-01
1
200 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
1 Comment
 
LVL 39

Accepted Solution

by:
lcohan earned 500 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
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…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

832 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