December 12, 2022 at 11:16 pm
I tried to setup log shipping on two data centers. Server A in location A, serverB in nearby location B.
On the server there are multiple databases, I created the first logshiping database, I created the monitor instances on ServerB.
It works well.
I then tried to create another log shipping for another database, when I get to setup the monitor instance, I used the same one. Then it errors out when saving monitor instance. It looks like only the first log shipping works with monitor instance with no problem, but not all other log shipping databases following the first one. Is there a reason for that?
I understand it is best to create a separate instances for monitoring instances, we cannot afford to do that, maybe using express edition, but still it need more resource like a VM server setup. I want to do as much as possible to setup monitor instances on secondary server.
Thanks,
December 14, 2022 at 12:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 14, 2022 at 7:17 am
Can you post the error screenshot.
Regards
Durai Nagarajan
December 14, 2022 at 5:10 pm
Can you post the error screenshot.
Thank you for asking that. I tried to reproduce the error, by creating the second log shipping database on the server, but I cannot reproduce it, this time it succeeded, weird. but that is good.
I remember when it failed last time it failed at the step: error in saving monitor instance. Something about the linked server already exists. I know log shipping created a linked server. but this time I did not get the message even it exists already. Not sure why?
Thanks,
December 14, 2022 at 5:17 pm
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply