In accessible database

• jerrymedia

  Old Hand

  Points: 328

  More actions

  December 18, 2007 at 8:18 am

  #119296

  Do anyone know how to reset a database with status of 1073741824?

  And what is the meaning of 'cleanly shutdown' which is Microsoft Description for it.

  You will get this result if you run

  select status from sysdatabases

  Thanks,

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  December 18, 2007 at 8:22 am

  #761050

  Is the database set to autoclose or single user? If autoclose connecting to it should open it.

  Here is a link where someone else had this problem:

  http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=83&threadid=44601&enterthread=y

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• jerrymedia

  Old Hand

  Points: 328

  More actions

  December 18, 2007 at 8:44 am

  #761072

  Thanks for the link I ran

  alter database database_name

  set auto_close off

  ....and rest as they is history...