ravi@sql (12/3/2012)
no actually i closed sql server and opened am able to see other databases except which i wanted to connect.
Hello Ravi,
Are you able to connect to the database now? Do you see the database at all in SSMS? If yes, is it online or, you are seeing it is suspect mode?
If you are not seeing the database at all, you need to attach it. Right click on databases and click on attach. Then, browse to the physical location of MDF file for the database.