Restoring a Database using SQL Management Studio
At this point, enough information has been entered for the database to be restored. However, SQL backup files store information about where data files are copied so if there are any file system problems such as a the destination directory not existing or conflicting data file names an error will occur. These problems are common when restoring a backup created on a different SQL Server installation.
To review and change the file system settings, click the Options page on the left in the Restore Database dialog.
Use this function with caution as you can potentially restore database backup information on top of data files from a completely different database.
Generally, you can tell the databases differ based on the ‘Original File Name’ which is the internal name SQL Server uses to reference the respective files.
Choose the top option – “Overwrite the existing database” and click Ok. You will see the message below when done.