I inherit a setup of two nodes (primary & secondary replica) Availability Group.
On my secondary replica node, the SQL server instance default files are stored at:
My default primary replica node files are as follow:
When I look at the synchronizing database’s properties on my secondary replica, I see its database files as follow
They are primary replica node directories. Is this how it works in Availability Group?
That is when you look at the file group of your secondary replica database, they show the paths of the primary replica database even though the data file and log file are stored at a different local directory?
Go to Source