restoring SQL Server from backup into a database with different database name?
I found this link to be particularly helpful. I'll summarize below:
you are probably trying to restore the database on another existing active database. You can run the following query (albeit with your details filled in) to restore your database:



RESTORE DATABASE AdventureWorks
FROM DISK = 'C:\BackupAdventureworks.bak'
WITH REPLACE