I have a development laptop with SSMS Express 2012 with a 2012 db instance and a 2008 db instance. Have been using this configuration for over a year. Suddenly I am unable to use the restore wizard. The wizard will pick the backup file but when I select the "Files" option on the upper left to designate the location of the MDF and LDF the dialog hangs. I tried a repair, no luck.
Sql-server – SQL server 2012 restore wizard freezes
sql server
Related Question
- Sql-server – SQL Server 2012 Install error “The instance selected for installation is already installed and clustered on computer…”
- Sql-server – Scripting the copy of SQL Server production database to test environment
- Sql-server – User databases inaccessible after physical restart
- Sql-server – Restoring from an LDF file
- Sql-server – Cannot re-attach SQL Server Express database to the same server after detaching
- Sql-server – SSMS Restore Database Wizard questions while restoring to different destination
Best Answer
@Pat I have been facing the same issue for a long time, but a few minutes ago found way around it.
First of all DO NOT try to restore by right-clicking on an empty database. What you need to do is right-click on Databases and from the menu select Restore Database. In that UI you can use the Files option and the UI won't freeze.
Note: By doing this SQL will create your DB and restore into it in one go.
Hope it helps.