Loading

Mirroring Between two Servers

Abdalla Elawad

Hi Guys

Please Help Me

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?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abdalla Elawad9y ago
Below Link Help For Solution Mirroring :

https://www.codeproject.com/Articles/109236/Mirroring-a-SQL-Server-Database-is-not-as-hard-as
0
Bikesh Srivastava9y ago
Yes definatly you can use n number of server.
0