SQL Server 2014 Restore DB only has "Verify Backup Media" option I just downloaded SQL Server 2014 Management Studio. I got the backup files &quot;.bak&quot; from my colleague. When I try to do a restore from &quot;Database &gt; Restore Database...&quot;, the window dialog only has &quot;Verify Backup Media&quot; instead of &quot;OK&quot;, &quot;Cancel&quot;, etc.
Clicking the button the message on top of the dialog stated &quot;Backup media verified successfully&quot;, but the database is not restored.
Did I miss out any configuration during installation or perhaps user permission issue? I'm using &quot;sa&quot; user.
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.