filegroup to read_only prevents dbcc checkdb from running
My database uses a combination of partitions and file groups in a sliding window configuration. I have implemented the VLDB CheckDB pattern and found that all file groups must be in a read-write state for this to work. By placing some older file groups into a read-only state I was hoping to utilize partial backups to reduce backup times. As a workaround we are temporarily placing the file groups back into a readwrite state to allow the checks to continue - however to make sure our FG backups can be used in a restore the FG backups have to be retaken due to LSN changes
The following is the error that is raised when a checkdb is execuuted on when I have a file group in a read only state
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors
The SQL Server Design Guidelines states placing file groups into read only is best practice.
Peter Vandivier commented