Creating a database from a backup file I have a peculiar issue on my hands.  I have a few databases in my SSMS already (2014), and when creating a new database and performing a restore from a file that has never been used, it sets my main database to single-user mode.  During the restore I initially didn't realize it was moving the main DB to the new location.  I don't want this, but regardless of what I do it doesn't allow me to just restore this to the selected database.  I have been through the google search gauntlet, finding no results matching what I am experiencing.  I have also attempted to just create a new database by setting restore as my option, but the main database is selected.  Does anyone have a sure-fire way to get this issue resolved so I can add this other desired database to my system?
The RESTORE DATABASE command will create the database for you. 

Don't create it first because then it will have to be deleted by the RESTORE command and a type if safety check in there might not allow the restore unless you specify the REPLACE option.

Also, is the database in that backup was read only when the backup was produced, then it will be read only when restore. Just turn off that database option after you done the restore.