Here are detailed instructions on how to restore a database on SQL Server 2000.

Before you begin, you must have a backup copy of the database you wish to restore.  The backup file had to be created with SQL Server  (thus, not a .mdf file).  If the backup file is compressed, it must first be extracted.
The backup file must be copied to the hard drive before starting.  SQL Server won’t allow you to restore from a network drive, flash drive or CD. 

•  First you need to open SQL Server Enterprise Manager
  Click on the Start Button, then click on Programs / All Programs, then click on Microsoft SQL Server and then click on Enterprise Manager.
• Go to the list of all the databases stored on the server
  On the left, expand the tree until you reach the Databases node.  The tree should look something like this:
  • Console Root -> Microsoft SQL Servers -> SQL Server Group -> (computer name) -> Databases
• Now you must determine where to restore the database to  (physical location of data files on hard drive)
  
  • If you are replacing an existing database on the server, you must first locate the current data file locations.
    You can do this by right-clicking on the database you wish to overwrite and click on the Properties menu item.  Click on the Data Files tab.  In the list, there should only be one item.  Write down the path and filename in the Location column for the item.  This is where the data file is stored.
    Now click on the Transaction Log tab and write down the path and filename in the Location column.  This is where the log file is stored.
    Click Cancel to close the Properties dialog box.
  • If the database doesn’t already exist on the server, you should either locate a path to restore the database to or create a new one.
    For HR Manage, we usually create a folder in the root called HRManage and store all application related files there.  Under the HRManage folder, we create a Data and Backup folder.  One for storing the data files and one for storing database backups.  Your filenames will then be something like C:\HRManage\Data\HRManage_data.mdf for the data file and C:\HRManage\Data\HRManage_log.ldf for the transaction log.  Whatever you choose your filenames to be, write down the full path with the filename for use in the next step.
• Right-click on the Databases node, click on the All Tasks menu item and then click on Restore Database…
  
  • Restore as database:  If you are replacing an existing database, choose the database you are replacing from the dropdown list.  If you are restoring a new database, type the name of the database in the field.  (e.g. HRManage, HR_PeopleRes, etc.)
  • Restore:  Click on the From Device option.  Then click on the Select Devices button, then click on the Add… button and browse for the SQL Server backup file that you copied to the hard drive.  Then click Ok until you’re back at the main Restore Database dialog box.
  • Now click on the Options tab.
  • Select the Force restore over existing database checkbox
  • In the list, type the full location of the data file and transaction log in the Move to physical file name column as you wrote it down in the previous step.
• Click Ok to restore the database