Sample Header Ad - 728x90

Cannot back up a read_only database with FILESTREAM

1 vote
1 answer
469 views
I'm facing a strange issue where my backup fails with the message: >Msg 3906, Level 16, State 1, Line 5 >Failed to update database "MyDBB" because the database is read-only. >Msg 3013, Level 16, State 1, Line 5 >BACKUP DATABASE is terminating abnormally. I saw a post talking about in-memory objects causing that issue, but in this case, there is no "memory optimized data". There is a FILESTREAM file but I couldn't find any documentation explaining this behavior. Has anyone faced this issue before? Any way to work around it without setting the DB to READ_WRITE? I think (can't find evidence to prove it) that the backup used to work.
Asked by Dominique Boucher (3297 rep)
Feb 28, 2024, 03:56 PM
Last activity: Feb 11, 2025, 08:02 PM