We implement SQL based ERP systems and use SSRS as a reporting platform reading directly from the live database. The scope of our SSRS reporting has now grown to such a degree I feel it is appropriate to start reporting offline as I suspect the performance issues some of our larger clients are experiencing might be due this dual use of the live database. I aware of terms such as "replication" and "transaction log shipping" but I have no practical experience of these and any other methods of duplicating a sql database and the relative pros and cons of each. I would suspect the parameters of the duplication will influence the best option so in our case these would be duplicating databases of between 10-100 Gig on an overnight basis in both 2005 and 2008 standard edition installs. Any advice in this regard gratefully recieved. Chris.