At my new job we have a SQL 2012 Always On Cluster. I'm looking at wanted to re-index some of the databases and want to change the recovery state to simple when re-indexing to limit log growth. Don't believe I can change recovery mode with Always on. Could do a rebuild online? Does anyone have best practice experiences they could share?
Appreciate insight