Missing databases

  • 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

  • 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]

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply