Forum Posts

DBCC CHECKDB with readonly filegroups

I can’t believe this. I’ve got a large (2+ TB) database that I want to do daily integrity checks on. Because it is so big, I was using PHYSICAL_ONLY. Here’s the command:

DBCC CHECKDB(BigDB) WITH PHYSICAL_ONLY, TABLERESULTS, NO_INFOMSGS, ALL_ERRORMSGS

I very quickly get this error:

Msg 5030, Level 16, State 12, Line 1 The database [...]