question

Wilfred van Dijk avatar image
Wilfred van Dijk asked

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?
alwaysondatafiles
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.