How to change monitor server for existing log shipping setup database in sql server?
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.
Check log shipping working fine or not?