>hello,
>
>can anyone help me? i have downloaded a *.bak file from our remote server in my win2k professional (both with a sql server 7) now i want to restore this *.bak file to the original database in my local computer so i can use the data to test my asp pages connecting to my local sql server. if anyone knows how to do this, please contact me. thanks!

You can also do this from the SQL Enterprise Manager as follows:
- Expand the server node where you want to restore.
- Right-click Databases and select All Tasks->Restore Database.
- In the "Restore As Database" type the database name.
- Select Restore -> From Device option.
- Click on the Select Devices button.
- On the "Choose Restore Device" dialog click on the Add button.
- Select your database backup file by browsing to it.

After this point you can click the OK buttons to finish restoring or select the options Tab to change special database settings as restoring for single user, among others.

HTH