-3

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

SNew
  • 109
  • 1
  • 2
  • 10
  • This question really looks like it belongs on [Database Administrators.SE](https://dba.stackexchange.com/). – Andrew Morton Apr 23 '21 at 20:51
  • What version of SSMS are you using? – squillman Apr 23 '21 at 21:05
  • I'm automatically suspicious of a database being called `BCP`. Is this really an SQL Server `.bak` backup file, or is it an export from the [`bcp.exe` utility](https://learn.microsoft.com/en-us/sql/tools/bcp-utility) that someone has renamed to have a `.bak` extension? – AlwaysLearning Apr 23 '21 at 23:21
  • @AlwaysLearning the database name itself is bcp and I tried with more than 5 databases from 2008 and it fails with the same error message. The same .bak file works again if I restore in 2008 . It is back up from ssms in 2008 and no utility etc – SNew Apr 24 '21 at 22:02
  • @squillman SSMS 18 – SNew Apr 24 '21 at 22:03
  • 1
    Hard to tell because the screen shot is cropped so much, but that kind of looks like the Database > Tasks > Restore > Files and Filegroups... wizard. You might want to try the Database > Tasks > Restore > Database... wizard instead. – AlwaysLearning Apr 25 '21 at 00:31
  • Also if you continue to have problems... near the top-left corner of the SSMS wizard windows is usually a Script button. Choose Script > New Query Editor Window to show the T-SQL script that the wizard intends to use and then edit your SO question to include that script. – AlwaysLearning Apr 25 '21 at 02:24
  • @AlwaysLearning Restore database works but it is strange that it fails using restore >files and filegroups – SNew Apr 26 '21 at 15:09

1 Answers1

0

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

SNew
  • 109
  • 1
  • 2
  • 10