sql-serverssmsdatabase-administrationdatabase-restoressms-17

SQL restore is failing with an error when using SSMS


SQL restore is failing with an error with the below error. The backup is from 2008 and tried on 2017 and 2017 express, it fails. The .bak size is 100 MB.

enter image description here


Solution

  • Database > Tasks > Restore > Database... wizard has worked. Thank you @AlwaysLearning