We are using SQL Server 2005 SP3. We currently have a production database that we want to replicate to another SQL server. The purpose for the second SQL server is to run reports and testing so it doesn't affect the production environment performance. My question is what would be the best method to do this? The production DB is around 280 GB with logs around 170 GB. We were thinking of doing log shipping but not sure if that is the best method. Data doesn't need to be up to date and can be at least 24 hours behind production environment. Thanks in advance for your help!