Home Forums SQL Server 2008 Data Corruption (SS2K8 / SS2K8 R2) Check Catalog Msg 3857, State 1: The attribute (owning_principal_id=NULL) is required but is missing for row (principal_id=9) in sys.database_principals (type=R). RE: Check Catalog Msg 3857, State 1: The attribute (owning_principal_id=NULL) is required but is missing for row (principal_id=9) in sys.database_principals (type=R).

  • May 3, 2017 at 11:25 pm

    #1941038

    Staggerlee - Wednesday, April 26, 2017 1:34 AM

    Hi, 

    We've had a vm crash which has caused a lot of corruption. all my errors seem to be in sys.database_principals..  which seemed easy to fix!

    I thought dropping the principal id user and recreating would resolve it but now it looks like I have possible made it worse..  when i run dbcc checkdb i now get

    Msg 0, Level 11, State 0, Line 0
    A severe error occurred on the current command. The results, if any, should be discarded.
    Msg 0, Level 20, State 0, Line 0
    A severe error occurred on the current command. The results, if any, should be discarded.

    Is there way back from this? Any ideas on how you should clear up the orginal error (I still have a few databases with it, so hoping there is a nice clean way to do it)

    Thanks for any advice.

    You can try to repair database by using inbuilt feature Repair_Allow_Data_Loss. But this will delete your data and that's why recommended not to use this. Or if you have a recent clean backup available. you may try to restore it from this. IF not best is to use
    this option to repair your SQL Server database using SQL Server database recovery tool.  As, to save your crucial data from deletion this is the best recommended option.