Starting up database

• TRACEY-320982

  SSChampion

  Points: 13653

  More actions

  December 10, 2008 at 6:32 am

  #197075

  A restore was done on a database yesterday everything worked - server was restarted.

  I have an error in the log file saying starting up database which is occuring every 1 minute.

  Is there a way to stop this i have taken database offline and nothing is preventing this error coming in

  Thanks

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  December 10, 2008 at 6:43 am

  #910294

  I have an error in the log file saying starting up database which is occuring every 1 minute.

  Set the AutoClose property to False.

• Jonathan Kehayias

  One Orange Chip

  Points: 26778

  More actions

  December 10, 2008 at 7:30 am

  #910346

  Make sure you turn off Autoshrink if it is on while you are in the options.

  Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
  My Blog | Twitter | MVP Profile
  Training | Consulting | Become a SQLskills Insider
  Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]