Jay Beta (3/15/2013)
You can also use SQL Server 2012 Always ON Availability Groups and using a secondary replica for reporting. This way you also accomplish redundancy and reporting at the same time.http://msdn.microsoft.com/en-us/library/ff877884.aspx#AGsARsADBs
I am aware of the read-only routing which is a very nice feature in 2012 for splitting reads and writes, but from a reporting standpoint, does that preclude the addition of indexes to the read-only instance that are not on the primary-instance?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato