Sql-server – What’s the best solution for distribution of one database over two servers

distributed-transactionssql server

I have a MS SQL Server 2014 database with large scale of data an lots of users;
and the RAID level is equal to 10. Now due to the rapid growth of data amount, I'm going to distribute this one database over two servers. What's the best solution for that?

Best Answer

Try using sql server failover cluster