I have A Database on SQL server 2016 SP1 on Primary site and another SQL Server as a DR server in DR site. DB is very small one and data growth is also small. DB is less than 1 GB right now and there may be about 1GB per month growth.
Connection between Primary site and DR site is 2Mbps dedicated
I need almost real time replication like Oracle RMAN sync [Oracle active data guard or data guard]
SQL and windows server - Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows Server 2016 Standard 6.3 <X64> (Build 14393: )
What would be the best SQL Server replication method except SQL Server Always on ? I need your opinion for DATA replication.
Hardware level, VM level replication will not work.