SQLTeam.com | Weblogs | Forums

What is th best way to create a failover plan to another server?


I am running a SQL 2012 Web dedicated server and want to write to secondary server that is at a different geographic location. What is the best way to configure to write data to the second server as a failover plan?


what version of SQL mate; have you looked at availability groups


If you are using Web edition, then you are limited in your High Availability options: https://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx#High_availability.

Log Shipping is pretty much your only option.