I have a SQL 2005 database that is currently 15GB in size. We do a lot of web / intranet based reporting from thsi system and we're seeing a performance hit as a result.
I'd like to create a copy of the live database on another server and have it continuously updated from the live db.
What is the most efficient way to do this, bearing in mind the copy database will never be changed so I only need the synchronisation/replication to be 'one-way' but we can't deal with a lag of more than 15 minutes.
Both servers are running Windows 2003 and SQL 2005 standard (not enterprise)