Sunday, March 11, 2012

Detached Database Problem

Hello,
Does anyone know what would cause a database to automatically detach itself
from the server? We have been having a problem the past couple of weeks
where a random set of databases would detach themselves from the server.
TIA,
DanNo that's not normal. I would put a trace on the database
to determine who or which process is causing this.
>--Original Message--
>Hello,
>Does anyone know what would cause a database to
automatically detach itself
>from the server? We have been having a problem the past
couple of weeks
>where a random set of databases would detach themselves
from the server.
>TIA,
>Dan
>
>.
>|||Dan,
Something must be detaching the database. Use Profiler to identify who
or what this might be. SQL Server will not do this without instruction.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
solex wrote:
> Hello,
> Does anyone know what would cause a database to automatically detach itself
> from the server? We have been having a problem the past couple of weeks
> where a random set of databases would detach themselves from the server.
> TIA,
> Dan
>

No comments:

Post a Comment