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 |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2012-03-08 : 01:04:18
|
| Hi,i have several database all are working fine except only one database.i am getting following error message when try to open and access database using management studio.The database is not accessible (ObjectExplorer)my database storage on SAN. database is not listed under user mapping. please tell how to fix this.thx. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-08 : 06:20:43
|
| Look in the SQL error log. What are the exact error messages listed for this database?Are the SAN drives available? Are the data and log files where they should be? (check with Windows Explorer)--Gail ShawSQL Server MVP |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-03-08 : 15:12:14
|
| Assuming there are no relevant messages in SQL error logs - the drives are available - and you can't see anything else missing.Some other things to explore could be: a) check an owner exists for the databases b) has view to the database been revoked?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
The database is not accessible (ObjectExplorer)