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:
- We would like to use a SQL Server database (main).
- If main SQL Server does not work, we would like to use different SQL Server database with same data.
- 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?