happycat59 (9/25/2013)
I have been doing the restore to the reporting server daily Its is a 2 hr Manual process.
FYI : replication does support initializing the subscriber from a database backup - have a look at http://technet.microsoft.com/en-us/library/ms147834.aspx%5B/quote%5D
I looked at the article previously It still will keep my reporting server offline ( no real gain on the initialization time from what is being done now )
Transactional replication definitely is an option. You can set this up so that it runs continuously or when scheduled (e.g. during off peak time) if needed. Transaction replication only sends insert/update/deletes for tables that have been changed (ie. tables that have had inserts/updates/deletes done to them in the published database).
What would be the impact on my production server for this ( i know if i try to force a replication with the snapshot replication the DB Becomes Unusable during the process )