Hi, we currently replicate data from one of our main SQL Servers (mainly transactional replication) to an independent report server. Our main server is a cluster joined to a SAN. The report server is fast becoming unfit for purpose so we are looking to purchase new hardware and also hook the new report server up to the SAN.
My question is, should we continue to use Replication between our main server and report server, even though the discs will reside on the same hardware? Is there a 'better' way to make the data available for reporting other than using Replication?
My initial suspicion is that Replication will remain but I'd just like to throw this question out to see what other DBA's may have done in this situation.
Thanks Nigel. Snapshots are an Enterprise only feature and we're running Standard. I don't suppose there is anything wrong with keeping Replication, it just feels odd when the discs are on the same metal. It should be quick anyway, without any network latency etc......