June 19, 2018 at 12:24 pm
In a migration project. We need to mirror the production database (principal) to a migration database (mirror). This mirror process would last 3 days, during this period only new records and updated records from the production database should be mirrored.
During the same period in the mirror database we need to run a purge process (by DELETE statements) that last two day to cut off data.
My question is: is it possible to run the DELETES on the mirror database and simultaneously make SQL manager to mirror the new and updated records?
June 21, 2018 at 4:57 am
No,
the mirrored database is in recovery mode, and you are not able to delete rows.
Maybe you can use a snapshot to get a readable database, but no writes anymore. For this kind of scenario, you need a merge replication.
Kind regards,
Andreas
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply