Espelhamento de bancos de dados armazenados no SQL Server

We have a server in our company with Windows Server 2012 installed, in which is installed SQL Server 2012. In a remote place, we have another server with Windows Server 2016 installed.

We want our DB's storages in our master server mirrored in our slave storage (2016).

For so, we are looking for a professional who can explain us in practice such proccess through a simple database storage here.

The idea is to set just a table mirror.

Both servers have fixed IPs and a VPN connecting both (from the slave to the master) is already running. If the other way round has to be used (from the master to the slave), another VPN connection will have to be setted up.

Obviously, besides the demand, we are assuming that all the functionalities of our servers will remain as they are today.

PS.: The software is in portuguese (Brazil), but we can communicate in English and help with the job.

Microsoft SQL Serwer Windows Server SQL Administrowanie bazami danych

Numer ID Projektu: #20112335

O projekcie