Cause of DB restarting

Hello,
I have a SQL Server that drives some of my companies web
sites. There are several DBs on this server, however, only
one is having an issue.
It repeatedly restarts itself. This issue started this
past Friday. On that day the DB was in suspect mode.
Any idea on what would cause this one DB to restart and
not affect any other DB on that same server?
Any help would be appreciated.have you run DBCC CHECKDB()
Error logs ?
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Jim C" <tjnaz2001@.yahoo.com> wrote in message
news:7f2a01c344ef$093e5ba0$a401280a@.phx.gbl...
> Hello,
> I have a SQL Server that drives some of my companies web
> sites. There are several DBs on this server, however, only
> one is having an issue.
> It repeatedly restarts itself. This issue started this
> past Friday. On that day the DB was in suspect mode.
> Any idea on what would cause this one DB to restart and
> not affect any other DB on that same server?
> Any help would be appreciated.
>|||In addition to Allan's post:
What do you mean by "restart"? Did you set the autoclose database option?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jim C" <tjnaz2001@.yahoo.com> wrote in message news:7f2a01c344ef$093e5ba0$a401280a@.phx.gbl...
> Hello,
> I have a SQL Server that drives some of my companies web
> sites. There are several DBs on this server, however, only
> one is having an issue.
> It repeatedly restarts itself. This issue started this
> past Friday. On that day the DB was in suspect mode.
> Any idea on what would cause this one DB to restart and
> not affect any other DB on that same server?
> Any help would be appreciated.
>