Post reply

Cleanly Shutdown

  • May 21, 2003 at 4:50 am

    #58973

    The status column of the sysdatabases table can have various values which are documented in BOL. All are straightforward with the exception of the last one.

    1073741824 - cleanly shutdown

    I can't find any reference to this anywhere - does anyone know what this represents?

    Thanks

  • May 21, 2003 at 8:30 am

    #457973

    When you take a db offline without an error, the entry for status is - in my case - 1077936640 which is the sum of cleanly shutdown, offline and autoshrink. So my guess is this value indicates that everything's ok.

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • May 21, 2003 at 8:42 am

    #457977

    That would appear to make sense.

    However it appears on only one of my databases and that is Model - this database is certainly not offline.

    I'll play around with taking db's offline and see what I get.

    Thanks anyway

  • May 22, 2003 at 12:46 am

    #458091

    Well, status in my model db is 0.

    Good luck!

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

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

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