• +1 for exploring Replication

    This might be the most common use-case for implementing Transaction Replication with a real-time Push Subscription. A nice benefit is that you can have a separate index structure on the reporting server database and the data movement from the Publisher will not be affected. This comes in handy because most times the people using the Subscriber database for reporting have far different querying needs than do the people or applications querying the Publisher database.

    The basic relevant how-to articles:

    Step 1: How to: Create a Publication and Define Articles (SQL Server Management Studio) - SQL Server 2008 R2

    Step 2: How to: Create a Push Subscription (SQL Server Management Studio) - SQL Server 2008 R

    Replication is a complex subsystem within SQL Server and may be the one with the most variations on how you can set it up so I would recommend doing some reading and some testing in a non-prod environment before making a decision to go with it.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato