Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Detach Database

Author  Topic 

jodyreenan
Starting Member

3 Posts

Posted - 2004-12-22 : 10:35:33
I am running an SQL database through MSDE 2.0. Every time I reboot the computer the database detaches itself. How do I prevent this from happening?

nr
SQLTeam MVY

12543 Posts

Posted - 2004-12-22 : 11:26:06
It's probably failing to attach.
Have a look in the sql server log and nt event log to see if there are any failure messages on startup.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -