debugsqlMinor
Restore Database wizard won't open in SSMS 2014
Viewed 0 times
wizardssmsopendatabasewon2014restore
Problem
On a dev machine running Windows Server 2012 R2, I just upgraded SQL Server from 2012 to 2014.
Using SQL Server Management Studio 2014, when I right-click a database and go to
No errors or crashes are in Event Viewer. The cursor doesn't even turn into an hourglass.
Using T-SQL to restore works fine, and if I go back and use SSMS 2012 it works fine. Any ideas on how to get the wizard to work in SSMS 2014?
I am connecting to the same instance of SQL Server in both versions of SSMS, and I have tried running SSMS as an administrator.
It is Service Pack 1:
Using SQL Server Management Studio 2014, when I right-click a database and go to
Tasks -> Restore -> Database... nothing happens. The Restore Database wizard does not appear as expected. No errors or crashes are in Event Viewer. The cursor doesn't even turn into an hourglass.
Using T-SQL to restore works fine, and if I go back and use SSMS 2012 it works fine. Any ideas on how to get the wizard to work in SSMS 2014?
I am connecting to the same instance of SQL Server in both versions of SSMS, and I have tried running SSMS as an administrator.
It is Service Pack 1:
Microsoft SQL Server Management Studio 12.0.4100.1
Microsoft Analysis Services Client Tools 12.0.4100.1
Microsoft Data Access Components (MDAC) 6.3.9600.17415
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 9.11.9600.18125
Microsoft .NET Framework 4.0.30319.34209
Operating System 6.3.9600Solution
In my case I just wanted to restore a database from device (full backup, copy-only). So this workaround worked for me. Right-click "Databases" and go to "Restore Database..." (instead of selecting the database). This should open up the wizard because there is no history to be loaded.
Within the options I selected "Overwrite the existing database" and I deselected "Take tail-log backup before restore".
Within the options I selected "Overwrite the existing database" and I deselected "Take tail-log backup before restore".
Context
StackExchange Database Administrators Q#125294, answer score: 5
Revisions (0)
No revisions yet.