Are there any ways to replicate sql server production database to a standby database? I notice that there is a feature called 'continuous replication', does it do in real-time? what is the time-lag? Are there any potential data loss (i.e., production transaction
committed but production db corrupted before the transaction is sent to standby)? Is the standby database available for read access during the replication?
View Complete Post