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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2011-11-07 : 07:41:35
|
| Hi Everyone,I have sql server 2008 sp1 instance. It is test standalone instance.Scenario is , i am not able to bring the sql instance.1. Someone has stopped sql server. 2. Went to physical data dir location and deleted some of test user db's3. When i am trying to start the sql, it is not coming online.How to bring my sql functional?Seems like , those database entries are still in sys.databases in master db and it trying to look for mdf and ldf files which aren't there any more!!How to come out of this situation? Is there any way to delete those entries in sys.databases so that sql ignores those missing db's?Thanks in Advance. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
sql not coming online