Multiserver administration - Insert data issues

• mtz676

  SSCrazy Eights

  Points: 9174

  More actions

  October 19, 2020 at 5:51 am

  #3798705

  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.

• Michael L John

  One Orange Chip

  Points: 27038

  More actions

  October 19, 2020 at 1:20 pm

  #3798840

  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/