SQL Server: where do I do put database so that it appears in the listbox

I am trying to restore a DB

I am getting this prompt, however I am u开发者_如何学运维nable to point to a database to restore from

Has anyone else experienced this horrific problem?

alt text http://img686.imageshack.us/img686/6569/56091244.png

Assuming you backed up a database to a file, click the From device radio button and follow the instructions.

One thing that might bite you in the backend is the fact that the SQL Server backup will contain the path where it wants to be restored to (the original paths).

If you select your backup file, make sure to select the checkbox in the Restore column, and then click on the Options page on the left:

Once you do, you should see the path where SQL Server wants to restore the data and log files to - you might need to adapt that to your own situation on your machine:

This is not right. You need to read the article OMG Ponies posted earlier: SQL Server: how do I export entire database?. You need to select "From Device", then from file and browse from the backup file you created". You sound like a noob, so be careful when handling this database.