Environment: SQL 2016 SP1, AG with 2 replicas, sync commit, no readable secondary. 1 file in the PRIMARY FG, 1 for the index FG. Problem: How to move the files for a database in this AG, from the current disk to a new disk, with no downtime, not taking it out of AG ?
I'd try to add a file to each file group, on the new disk, run shhrinkfile emptyfile, remove the empty files from the old disk, all on the primary. Log file will stay on the old disk. Not sure how to do it on the secondary.
Can someone please confirm I'm on the correct path, or improve on it, please ? Thank you.