How do you open a detached database in SQL Server 2005

I try to open the database YourGuruDB1 in this directory:

D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

I go to file and then open file.. Then it tells me, that i must ensure that the database is installed..

Previously I backed up and restored the database, and then detached it..I have no idea where the program dropped the database to..

But I want to open it with all its stored procedures like any ot开发者_高级运维her database that i have in SQL Server 2005

If you detached it, you need to attach it.

Just right click on the "Databases" node in SQL Server Managment Server, click "Attach", navigate to the data file you indicated, and tell it to attach the database.

You have to attach back the database.