Log Shipping Reconfiguration Failed...

  • Hi Experts..

    when i was configured the logshipping the server IP address was 192.168.0.xxx ,And I configured Logshipping successfully.

    Now the ip Address was changed to 192.168.0.yyy for some security purpose ,When am trying to remove the Secondary server its throwing some errro.

    So if i want to change the ip address to 192.168.0.yyy of secondary server what should i do.

    Regards

    Chowdary...

    Regards
    Chowdary...

  • Sounds like you will need to force remove logshipping by using the stored procs in MSDB to remove all the primary and secondary plans

    http://msdn.microsoft.com/en-gb/library/ms189071.aspx#TsqlProcedure

    I would then reconfigure the logshipping plan to use the FQDN of the servers rather than IP so then you don't run into this issue again

  • Chowdary's (9/2/2014)


    Hi Experts..

    when i was configured the logshipping the server IP address was 192.168.0.xxx ,And I configured Logshipping successfully.

    Now the ip Address was changed to 192.168.0.yyy for some security purpose ,When am trying to remove the Secondary server its throwing some errro.

    So if i want to change the ip address to 192.168.0.yyy of secondary server what should i do.

    Regards

    Chowdary...

    Execute in the following order

    On the secondary server

    exec sp_delete_log_shipping_secondary_primary

    @primary_server = 'primary_server'

    , @primary_database = 'primary_database'

    exec sp_delete_log_shipping_secondary_database

    @secondary_database = 'secondary_database'

    On the Primary server

    exec sp_delete_log_shipping_primary_secondary

    @primary_database = 'primary_database',

    @secondary_server = 'secondary_server',

    @secondary_database = 'secondary_database'

    exec sp_delete_log_shipping_primary_database

    @database = 'database'

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • This was removed by the editor as SPAM

  • Generally you'd remove the secondary information first, especially if you plan to re use the primary config 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Thank you All for giving your valuable Response,

    But after Deleting the Secondary DB and all the jobs(Primary and Secondary) also i cant remove the Log shipping because it is asking to connect the secondary server but there old ip address was there that to login mode is in disable mode i cant able to enter the new ip address .

    Can anyone help me out...

    Regards
    Chowdary...

  • have you executed all the queires i supplied above, it looks like you havent ran

    exec sp_delete_log_shipping_primary_database

    @database = 'database'

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Thank you all for your response,

    Finally i took the Backup and restored then reconfigured the Log shipping Successfully.

    Regards

    Chowdary...

    Regards
    Chowdary...

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply