When right clicking on a database in the Object Explorer panel of SQL Server Management Studio 2014, and then expanding to "Tasks>Restore>Database...", then selecting it, the database restore dialog does not appear.

Please note that: 1 - I was using this before and then it stopped working 2 - It works on some other databases! 3 - Restarting Management Studio or even rebooting the client machine (Windows 7) does not solve the problem.

Any idea how can I fix this?

  • Have permissions on the database itself changed? (Wild guess.) – Katherine Villyard Jul 13 '15 at 22:48
  • Nothing has changed... – Adam Jul 14 '15 at 8:24
  • Can you try to "restore" the SSMS window or if you have multiple monitors, move it to another monitor and try again? – Peter Jul 23 '15 at 21:39

I had the same error. SQL server studio 2014 doesn't like error "Unable to create a restore plan due to break in the LSN chain". And fails to open restore dialog. Fix LSN chain by issuing FULL backup. After that restore dialog should work.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.