Missing databases

• MJ-1115929

  Ten Centuries

  Points: 1278

  More actions

  September 14, 2009 at 11:50 pm

  #215249

  Hi Experts,

  I came across a small prob that when i run dbcc sqlperf(logspace).It is not showing all databases .I am having 96 databases out which 76 are only displaying the logsize and logspace used.

  I believe that only database having recovery model set to Full will display

  Is there any onther option to display those are missing?

  Help in this is highly appreciated

  Thanks in advance

  Milesh J

• Silverfox

  SSC-Insane

  Points: 23150

  More actions

  September 15, 2009 at 2:46 am

  #1053636

  MJ (9/14/2009)

  ---

  Hi Experts,

  I came across a small prob that when i run dbcc sqlperf(logspace).It is not showing all databases .I am having 96 databases out which 76 are only displaying the logsize and logspace used.

  I believe that only database having recovery model set to Full will display

  Is there any onther option to display those are missing?

  Help in this is highly appreciated

  Thanks in advance

  Milesh J

  Just tried out your theory, dbcc sqlperf works for all databases regardless of recovery mode.

  can you show the recovery mode for the other databases that are not being displayed.

  --------------------------------------------------------------------------------------
  [highlight]Recommended Articles on How to help us help you and[/highlight]
  [highlight]solve commonly asked questions[/highlight]

  Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
  Managing Transaction Logs by Gail Shaw[/url]
  How to post Performance problems by Gail Shaw[/url]
  Help, my database is corrupt. Now what? by Gail Shaw[/url]

• MJ-1115929

  Ten Centuries

  Points: 1278

  More actions

  September 16, 2009 at 2:35 am

  #1054293

  You are right it will work regardless of the recovery mode.

  But do u have idea that wat will the cause of the databases that not being displayed.

  Thanks

  Regards

  Milesh