emile.milne (1/23/2013)
Thanks, thats not ideal. I think most people will use the replica for SSRS. Big flaw in the design then.If I want to tweak the index for reports they need to be added to the LIVE db. Very poor oversight.
Not really, Always On is first a high availablity solution, and second an alternate data source for reporting etc. In most situations I've found Replication an excelent option for reporting.
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.