I was of belief that changing compatibility mode on primary database in database mirroring would make the change for mirror database.
But it proved to be wrong. I queried using
sys.databases on Primary where i changed compatibility mode to 120 , however on its mirrored database compatibility level was still 100. Why?
Am i using the incorrect fn here sys.databases?
Also if it does not change what does it mean, do i need to do failover/failback to reflect?
What if i had log shipping secondary database in read only as well where this change needs to reflect? Do i need to rebuild log shipping then?