August 18, 2005 at 6:19 am
For the past couple of weeks, the particular database is automatically detached from sqlserver especially during after 11 PM(when datbase is not in use) . That too not daily .., but frequently. Is there any idea to what has actually happened for the detachement.
No defrag software running. Viruses not found - checked properly.
We had executed the command only DBCC shrinkfile reduced from 672 Mb to 30.1 mb for Log file.
Does the DBCC shrink file to 30 MB would have any impact on the database ?
Any suggestions
Pls Help
August 18, 2005 at 7:22 am
Check your jobs...see if there is one running at that time that includes the detach command.
-SQLBill
August 19, 2005 at 10:24 am
Are you sure it is being 'detached' or just being 'closed'. If it is being 'closed' that's an easy database option fix. If it is really being 'detached' then the only way is via 'sp_detach_db'. So checking your scheduled tasks is definitely the place to start.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply