MSSQL Management Studio 2014 not showing the "Tasks>Restore>Database..." Dialog

Question

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
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

score 3 · Answer 1 · answered May 31 '16 at 15:02

3

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.

answered May 31 '16 at 15:02

Sigitas

31
2

MSSQL Management Studio 2014 not showing the "Tasks>Restore>Database..." Dialog

1 Answers1