Master..sysperfinfo table

• Junie01

  Right there with Babe

  Points: 744

  More actions

  August 8, 2003 at 1:56 pm

  #58814

  I have a situation where this table is empty. Not quite sure how it happened, but may be linked with the installation of 'Cumulative Patch for Microsoft SQL Server (815495)'.

  Does anyone have any suggestions as to the best way to recover the data?

  I do have a backup of the master database taken before the table became empty.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  August 8, 2003 at 9:29 pm

  #469267

  Someone has similar problem. See http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15034&FORUM_ID=110&CAT_ID=1&Topic_Title=sysperfinfo&Forum_Title=SQL+Server+Agent

• Junie01

  Right there with Babe

  Points: 744

  More actions

  August 11, 2003 at 4:31 am

  #469356

  Thanks for that - I do have the error message mentioned in that email in my SQL Server log file