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).

• Staggerlee

  SSCertifiable

  Points: 5272

  More actions

  April 26, 2017 at 1:34 am

  #401995

  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.

• May 3, 2017 at 11:25 pm

  This was removed by the editor as SPAM