I'm having problems trying to  
restore the thephile-database-backup database file in SQL Server 
Enterprise Manager.
First of all, which DB do I put in the backup folder? there are 2 
different ones to download off the site?
one is 'thephile-database-backup.bak' and the other is 'thephile-database-
backup-sq-server-7.bak' 

anyway, I tried the second one. and followed every step:
Create a new database called thePhile 
Right click the new database, click All Tasks then Restore Database 
Select From Device 
Click Select Devices 
Click Add 
Use the filename box to select the thephile-database-backup.bak file. 
Click OK 
Click OK again 
Click OK once more 

But after I click the very last OK, it says:

Microsoft SQL-DMO(ODBC SQLState: 42000)
"the backup set holds a backup of the database other than the 
existing 'thePhile' database. RESTORE DATBASE is terminating abnormally "

can anyone tell me whats going on, this is really frustrating.

tahnks in advance!

I guess the -7 is for SQL Server 7.0; the other one is for SQL Server 2000.

When you restore from backup, there is an "Options" button, you need to 
check "force restore".  And you also need to make sure the path exists in 
your system or you can change the default path.

Hope it helps.

ok thanks, I got it to work.
I was confused,I just used the wrong database, 
thanks for the quick reply!