I need to set up a high availability infrastructure in SQL Server 2008 R2 on Windows Server 2008 R2.
I am planning on either doing Replication with Transactional Logs or Log Shipping. I would prefer Replication. However, Replication does not publish or replicates any table that does not have a primary key column. I do not know if the same is true for Log Shipping.
If the primary SQL Server 2008 R2, or publisher, goes down for good, can we get the subscriber to have the same data than the publisher even though tables that do not have a primary key column do not get replicated?
Does Log Shipping take into account those tables that do not have a primary key column as well as those that have a primary key column?
I hope I am explaining myself in a way you can understand what I am looking for.