Did you know that log shipped databases do not have to sit there collecting dust and not being used? However, there are certain situations where replication or Availability Groups are not the answer to the question of separating your reporting traffic.
You don’t need to build an actual data warehouse, you don’t want the complexity of Windows Cluster for Availability Groups, and you cannot use replication because your tables do not have primary keys.
We can use the long trusted Log Shipping technology and tweak a few settings and get a read-only copy of a database.
Click through to see how you can make use of those log shipped databases.