Cleanly Shutdown

• beath

  SSCrazy

  Points: 2939

  More actions

  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

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  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]

• beath

  SSCrazy

  Points: 2939

  More actions

  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

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  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]