0


I have a test database and I was able to see the database in SSMS and all of a sudden Its not listng my database and When I checked the mdf and ldf files they seems to be locked . I am using Sql server 2008 R2. Can anyone help me?

Improve this question
11
  • Is it not listing it in Object Explorer or in sys.databases?
    – KenWilson
    Commented Sep 28, 2015 at 19:49
  • no. I checked it
    – Sivajith
    Commented Sep 28, 2015 at 19:50
  • 1. Are you on the correct instance? Make sure you are connected to appropriate instance (Named or default)
    – KASQLDBA
    Commented Sep 28, 2015 at 19:51
  • 2. What do you mean when you say, mdf and ldf locked?
    – KASQLDBA
    Commented Sep 28, 2015 at 19:51
  • yes. And also I tried using local
    – Sivajith
    Commented Sep 28, 2015 at 19:51

1 Answer 1

Reset to default
2

Just converting the part of comment to an answer so as to close this question:

It seems like someone had the database detached, because of which database was not visible and hence you were also able to view its respective mdf and ldf.

Right Click Databases--> click Attach--> Choose the respective mdf files for the database in question.

Refresh and check , the database should be visible.

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.