SQL server error “No catalog entry found for partition ID xxxxx in database 12…”

• Abhishek

  SSCommitted

  Points: 1715

  More actions

  June 30, 2017 at 3:06 am

  #337908

  SQL server error “No catalog entry found for partition ID xxxxx in database 12…” repeated logs in error log file 
  My SQL server already on 2012 SP3 CU7 , is it a scenario of data corruption and can it lead to SQL server crash issue
  Experts , your comments please ?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 30, 2017 at 3:34 am

  #1948890

  Run the following in the database with the problem, post the results

  DBCC CheckDB WITH NO_INFOMSGS

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Abhishek

  SSCommitted

  Points: 1715

  More actions

  June 30, 2017 at 3:40 am

  #1948891

  its been running since quite sometime now ... i am waiting for checkdb to complete .., will post in a while

• Abhishek

  SSCommitted

  Points: 1715

  More actions

  June 30, 2017 at 4:01 am

  #1948892

  Command(s) completed successfully.

  without any error message when i run : DBCC CHECKDB (equip_event_tracking) WITH ALL_ERRORMSGS, NO_INFOMSGS

• July 2, 2017 at 11:56 pm

  This was removed by the editor as SPAM