September 2, 2014 at 1:13 am
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...
September 2, 2014 at 2:23 am
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
September 2, 2014 at 4:07 am
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" 😉
September 2, 2014 at 4:16 am
This was removed by the editor as SPAM
September 2, 2014 at 4:26 am
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" 😉
September 2, 2014 at 6:53 am
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...
September 2, 2014 at 7:24 am
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" 😉
September 3, 2014 at 3:53 am
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