Im an Oracle DBA by trade and been tasked with setting up transaction replication in SQL Server 2014 from one host to another.
I set up a test DB, configured a publication, set up a subscriber DB, set up subscriptions and transactions are replicating. All good to here.
In oracle we have dataguard which allows us to replicate but we need to manually flip it to active mode to query or run transactions against it.
In my replicated subscriber database in SQL Server, that doesnt seem to be the case, it seems to be open for any transactions as well as taking transactions from my publishing database.. Is there a way that I can put it into a "standby" mode like oracles dataguard and still receive transactions so I'm in control of it?
Ive gone over documentation but not seeing anything jump out that answers.