Post reply

dbcc sqlperf(logspace)

  • November 5, 2007 at 2:52 am

    #69279

    Hi All

    I use dbcc sqlperf(logspace) (on a Windows 2003 server - SQL Server 2000 Sp 3a) and I get an incomplete list of my database.

    I retry (F5): a "random" number of databare are displayed.

    I run select * from sysdatabases and I notice different status codes but I don't find a link between status codes and missing databases in dbcc.

    Can you help me please?

    Thank you

    Enrica

  • November 5, 2007 at 3:04 am

    #748148

    I encountered the same problem months ago i think the problem is with the auto close being checked in your database property check each of your databases to see those databases that have auto close option checked and unchecked it so that when you run dbcc sqlperf(logspace) all databases will be displayed.

    Procedure:

    1. choose a database

    2. right click then choose properties

    3. see if auto close option is checked

    4. unchecked it

    EDIT: My bad i have a script that will select all the options of the databases but at the moment i can not remember where i put it :D. If i saw the script ill post it right away....

    "-=Still Learning=-"

    Lester Policarpio

  • November 5, 2007 at 3:55 am

    #748164

    Thank you very much, it works fine!

    Bye

    Enrica

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

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