Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Forgive me if I am not using all the proper terms but I have databases that will detach themselves from SQL Server. In SQL Server Management Studio the plus sign will be missing next to the database, or the database will have no tables.

Now the fix for this is easy, simply detach and attach the database and we're back up and running. BUT what is the cause for this?

I actually did see where AutoClose is on and it is recommended to NOT be due to many performance issues... and actually read all of those pages before this :) but I didn't see anything about the issue I was having so I didn't think that was the issue
–
Patrick GarmanDec 2 '11 at 15:40