Problems by synchronisation to azure

M. Weißberg 21 Reputation points
2020-12-03T15:52:05.417+00:00

Hi,

while the synchronisation between our mssql servers errors shown like the picture. I know what this means but how can i find the corrupt record ?

Thanks for help.

Mike

44854-bild1.jpg

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,600 questions
0 comments No comments
{count} votes

Accepted answer
  1. Erland Sommarskog 100.8K Reputation points MVP
    2020-12-03T22:50:56.933+00:00

    Something like this:

    SELECT *
    FROM   source a
    WHERE s.Messbereich IS NOT NULL  
      AND  NOT EXISTS (SELECT *
                       FROM  Messbereiche M
                       WHERE s.Messbereich = M.Messbereich)
    

    You would need to get the data into some temp table table, so that you can run the query.


1 additional answer

Sort by: Most helpful
  1. CathyJi-MSFT 21,066 Reputation points Microsoft Vendor
    2020-12-04T03:43:14.193+00:00

    Hi @Milan ,

    The error message is related to Foreign Key, suggest you try the suggestion from below blog.

    Troubleshooting SQL: Agent job failed with Error 547 and Error 3621.

    Best regards,
    Cathy


    If the response is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments