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.
| Author |
Topic |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2007-08-22 : 11:28:31
|
| After reboot, some db were detached, some not.How come? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-22 : 15:05:31
|
| Rebooting shouldn't detach dbs. Any error in sql server log? |
 |
|
|
staronline
Starting Member
1 Post |
Posted - 2010-09-16 : 04:55:34
|
| I had a similar problem. Whenever I restart the server, 3 out of about 10 databases would not start. Rest would start fine. SQL Log would show the OS file Access Error for these 3 databases mdf files. Finally I was able to resolve the problem.I had SQL 2000 and SQL 2005 both running on my server. On both these I had 3 common database names which were hence not starting. SQL 2000 starts before SQL 2005 and hence it would not allow SQL 2005 to open the 3 databases which were common between the two and thus giving File Access Error.In Windows Task Manager under the Processes Tab, check if you have 2 instances of Sqlserver.exe running. Then you probably have the same problem as mine.Switch off one of the instances i.e. SQL 2000 or SQL 2005 or some other version of SQL which ever you are not using from auto starting on reboot and your problem should be resolved. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-09-16 : 05:41:23
|
| Please note: 3 year old thread.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
After reboot, some db were detached, some not.