• Log shipping is mainly used to have a backup server in case of hardware failure on the production server. This should already be in place on production system. If your main server goes down this becomes renamed to that server that went down- so as to keep things up and running. You need to understand your report users and how latent data can be. Do they need up to the minute granular records? Can information be one day behind? If the former I would use transactional replication. if the latter- you can restore from a backup if you do these nightly or create and schedule an SSIS solution to copy just those tables for the time frame needed.

    I hope this addresses your concern.

    ----------------------------------------------------