A customer sent us a .bak file from a 2019 instance. I was running 2014 (other customers are) and knew that 2019 would not restore to it. So I installed 2022Dev, went into SQLMS, and created a new DB to hold the data.

I then right-clicked the new DB, and selected Tasks->Restore->Database. I selected Device and selected the file. The name of the file appears beside the Device label as expected.

However, the Database: combo below the name is empty. I cannot select the DB to restore and the OK button remains greyed out:

enter image description here

Having never seen this before, I did some poking about here and found some seemingly unrelated posts about permissions, but to be safe I clicked the Unblock and set the permissions to all. No change.

I'm a bit lost here, any suggestions?

  • what comes back if you restore headers or file lists from that file? Feb 9 at 18:47
  • @ErikDarling - OK, that was useful, I've never had to try this in SQL before. Running either of those returns an error: "Cannot find server certificate with thumbprint '0x44126restclipped' Feb 10 at 1:05
  • The backup is encrypted and you are missing the encryption certificate. You need to BACKUP CERTIFICATE from the original, then restore it to master on your new machine. Feb 10 at 19:03
  • 1
    Does this answer your question? Can I recover a TDE certificate by restoring the MASTER database? Feb 10 at 19:06
  • @Charlieface - well it answers it, but offers no solution. The certificate in question is located on a customer's cloud server and there's no way in heck we're getting it. The solution is to simply back it up without encryption, and I'm talking them through it now. Feb 12 at 14:59


Your Answer

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

Browse other questions tagged or ask your own question.