Database is Detaching Reg | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database is Detaching Reg

for past 1 week my live database is detaching from the server
every morning it seems the database is detached.Being a live database the problem is very serious.
What will be the problem and pls help me how to resolve this
First of all You need to find out the cause or main victim who is detaching the DB.
This is very strange thing happening.
There must be some job or someone is doing it delibrately.
Perform a server side trace in order to see the activity.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Yes this seems to be somthin strange .As far i know i hav never heard any process making DBs detached.
Maybe you mean that it auto close and an entry is shown in the sql error log? If so turn of the auto_close option on the database.
Yes that might be the issue, she has mentioned .IF so , please refer to my previous post http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8734 rajiv
NewBie-23
]]>