Forum Discussion
Mirrored On-Premise SQL Server Database not updating
Hi nielsvdc , thanks for the response.
So couple of updates;
- I had to manually start the CDC on the database & the table, look like it didn't start by default.
- Removed the mirrored db completely, but still the same issue.
- I ran
EXEC as SQLUser
SELECT TOP 10 *
FROM CHANGETABLE(CHANGES [dbo].[Landtanks_Volume_Status], NULL) C
order by Time desc;
REVERT;This shows me the changed rows, so they are detected by the user, but they are not synced to the mirrored database.
It might have something to do with the Fabric Agent (who is up-and-running), I restarted it to make sure ; as for a very small table, we got this warning at creation time:
I've looked for some solutions online, but they are not really straight forward & would surprise me if it would be so hard to accomplish this..
Thanks !
And as an extra: I wasn't able to run the above queries, because the sp / columns did not exist.
The SQL Server edition is: Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64)
The gateway is on another server, but has acces to the SQL Server as we can read data.