SQL Server 2014 Restore DB only has "Verify Backup Media" option
After lots of searching it seems abit hard to figure out why restoring database only has the &quot;Verify Backup Media&quot; option in my SSMS.
I tried &quot;Restore Files and Filegroups...&quot; but hit another error &quot;The backup set holds a backup of a database other than the existing&quot;, until I came to this post, writing the script instead to restore the &quot;.bak&quot; file works for me.