Try this..
1. Right-click the database name, point
to Tasks, point to Restore, andthen click Database, which opens the Restore Database dialog box.
2. On the General page, use the Source for restore section to specify thesource and location of the
backup to restore.
3. On the Options
page, in the Restore options section, you can select anyof the following options,
· Overwrite the existing database .
· Preserve the replication settings .
· Restrict access to the restored .
· Prompt before each database backup.
4. Then click OK.