datafile has is_media_read_only=1, but is writable
Hi, I have this strange situation: SQL2012 AlwaysOn (11.0.5343) on Windows Server 2008R2 Std (yes, I know). Some databases in this Availabilitygroup have the [is_media_read_only] bit to TRUE, but other databases with datafiles on the same location haven't. Also, no errors occured and the database seems writable. The [is_read_only] bit is FALSE and the database is not in READONLY mode. No replication errors Could someone explain this?
The secondary databases in the Availability Group that are marked as readable will likely show that they have the is_read_only bit set. Others won't have that set because you can't read from them. Secondary databases in the availability group shouldn't be updatable at all, except from the primary.