Proceed below steps to change monitor server into new one in existing log shipping setup for a database.
First log into publisher database server and Right Click Publisher Database->Click Properties-
Select Transaction Log Shipping>Uncheck the Checkbox for ‘Enable this as a primary database in
a log shipping configuration.
Secondly Check the Checkbox for ‘Enable this as a primary database in a log shipping configuration
Now we can able to edit the Monitor server instance name settings.
Here we will change monitor server into a new monitor server name.
Click OK.
That’s it.
Check log shipping working fine or not?
Great, it is worked and everythig is fine in log shipping after changes.
ReplyDelete