Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using SQL Server 2008 Enterprise. I want to know how many different ways or different reasons why database (not instance, not server, but database) is stopped/started. I am analyzing SQL Server logs.

Currently as far as I know, two possible ways/reasons are -- taking database offline/online and stop/start instance/server.

thanks in advance, George

share|improve this question
up vote 1 down vote accepted

You could take the database offline, and the if the database is set to AUTO_CLOSE TRUE then the database will automatically be shutdown when the last user disconnects from the database. Both of these cases will show events in the log stating that the database was stopped.

share|improve this answer
Thanks! 1. Another way to start/stop database is to start/stop database instance, correct? 2. Do you think of any other ways to start/stop database? – George2 Sep 25 '09 at 16:52
you can start & stop a server, but not a database. Nothing other than the 2 that i've mentioned is coming to mind... – Scott Ivey Sep 25 '09 at 18:31
Thanks, question answered! – George2 Sep 26 '09 at 9:18

You can also attach / reattach a database.

Also, a database can be marked suspect, in recovery, etc.

What are you actually asking?

share|improve this answer
I find in SQL Server log, there is items like database XXX start and stop, and I want to find reasons why database start/stop because I have never explicitly start/stop SQL Server instances. Any ideas what are the possible ways we could start/stop database? – George2 Sep 25 '09 at 16:50
Reattach means? I am confused. – George2 Sep 25 '09 at 16:50

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.