2

I just downloaded SQL Server 2014 Management Studio. I got the backup files ".bak" from my colleague. When I try to do a restore from "Database > Restore Database...", the window dialog only has "Verify Backup Media" instead of "OK", "Cancel", etc.

Clicking the button the message on top of the dialog stated "Backup media verified successfully", but the database is not restored.

Did I miss out any configuration during installation or perhaps user permission issue? I'm using "sa" user.

asked Jul 17, 2020 at 3:43
1
  • Any chance you could attach a screenshot perhaps? Commented Jul 17, 2020 at 14:43

2 Answers 2

1

After lots of searching it seems abit hard to figure out why restoring database only has the "Verify Backup Media" option in my SSMS.

I tried "Restore Files and Filegroups..." but hit another error "The backup set holds a backup of a database other than the existing", until I came to this post, writing the script instead to restore the ".bak" file works for me.

answered Jul 17, 2020 at 4:08
-1

Please check your screen resolution. Maybe your monitor is cropping restore backup screen becouse of low resolution. It simply does not fit in screen so you can not see the OK buttons.

answered Sep 4, 2021 at 12:36

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.