Best practise how to sync a SQL Server database

66 Views Asked by At

What is best practise if we have application using a SQL Server database and we would like to have backup if SQL Server not work?

Our scenario:

  1. We would like to use a SQL Server database (main).
  2. If main SQL Server does not work, we would like to use different SQL Server database with same data.
  3. If main SQL Server works again, we need to sync data back to main SQL Server database.

Failover Cluster is an option, but are they any other options?

0

There are 0 best solutions below