Data Copy
two strategies:
try to share sql request across servers
try to code functionalities to use different servers - which uses different set of tables.
https://www.youtube.com/watch?v=A8lSl8nO1r4
Log shipping
Data Mirroring
Always on group sql 2012
Seamless failover is only possible in Always on group sql 2012.
Load Balancing:
no out of box solution for SQL DB load balancing which is transparent to application.
two strategies:
try to share sql request across servers
try to code functionalities to use different servers - which uses different set of tables.
https://www.youtube.com/watch?v=A8lSl8nO1r4
