I am getting the error "memory mapped file write failed" while trying to run Snap Shot Agent in Transactional Replication. Snap shot works fine if the table is having only a few hundreds of rows. And fails if the table contains few thousands of rows. The SQL Server is installed on a Linux Server and tried many suggestions found online. But to no avail. Can anyone please guide me on this.
1 Answers
We've also had a similar issue with Snapshot Replication. As a workaround, we split the replication into multiple publications. After several trials, we were able to successfully replicate our database which contains more than 1000 tables with 5 publications. Except for 1 table with a text column (containing big xml), maybe we need another workaround in this case.
If you are only replicating 1 large table, you might try splitting it using Filter Rows.
We are using SQL Server 2019 Developer Edition on Ubuntu 18.04 LTS Server Linux Container with 8GB RAM. Other databases are installed on this server: MySQL 8.0, MariaDB 10.5, and PostgreSQL 12.5.
Related