Restore BAK - No Source Database

• ringovski

  Hall of Fame

  Points: 3521

  More actions

  July 30, 2019 at 11:35 pm

  #3667385

  Hi All

  I am trying to create a new database using the restore wizard in SSMS from a backup .BAK file and it doesn't work.

  Performed backup on original instance. Copied .BAK file to new server. In SSMS right click on new  instance select restore data base, device, path to .BAK file, file is checked, but source database is blank. So I can't proceed with the restore, what did I miss?

  

• Alejandro Santana

  SSCommitted

  Points: 1828

  More actions

  July 30, 2019 at 11:39 pm

  #3667386

  This usually happens if your backup have been encrypted, it happened to me when it was encrypted by certificate or maybe different sql server versions, if the backup is from newer versions you wouldn't be able to restore it, but for that case, i think the restore wizard would tell.

  Try to restore through scripting and post the error message.

• Andrey

  Right there with Babe

  Points: 779

  More actions

  July 31, 2019 at 9:47 am

  #3667472

  I saw such issues in the past when SSMS had issues reading BAK files created with option "copy_only".

  Try to run the following commands from query window:

  restore headeronly from disk='full_path_to_BAK_file'
  
  go
  
  restore filelistonly from disk='full_path_to_BAK_file'
  
  go

   

• andreas.kreuzberg

  SSCertifiable

  Points: 6119

  More actions

  August 2, 2019 at 12:41 pm

  #3668226

  Hi,

  I think, if you choose device, you can't choose source database. If you decide to restore from a backup file, why you would choose a source database?

  Kind regards,

  Andreas