October 19, 2020 at 5:51 am
I built multiserver administrative servers.
My principal server has 1 job which I manually executed once;scheduled at 6:00 AM. Once I did this it created 1 job each on the other 3 mirror servers.So now I have 1 job per mirror server scheduled to 6:00 AM.The job is a simple tsql script with 3 insert statements
insert into A values('A',1)
insert into A values('B',2)
insert into A values('C',3)
But table A has 6 rows inserted(when it should only have 3 rows) on all 3 servers making it look like the mirror server jobs executed twice, but the job histories show one 1 execution on all 3 mirror servers.
Any ideas on what seems to be going on here.
October 19, 2020 at 1:20 pm
Define "Mirror server".
If you have some sort of replication on the main server that is pushing data to the other three, that could be the cause.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy