Hi Guys
We currently have one server with SQL Server 2008 R2 and Same database want to add another server. Is it possible to configure the 2 servers to work together? Ideally, we would like that if one goes down the other keeps working, and also load balancing while both are on.
What would be the best solution?