SQL Server Management Studio Not Presenting "Restore" -> "Database" Dialog

1 September 2015

I normally use a lot of backup / restore in SSMS to bring copies of production databases locally to develop or analyze, and on occasion I'd notice that doing the usual Right Click -> Tasks -> Restore -> Database... wouldn't bring up the dialog to continue.

So it turns out that this dialog doesn't actually appear unless you've previously made a backup of the database, which isn't always the case for me if I've been copying or restoring copies of databases from different machines, and not yet done a local backup.

Long story short, if you ever come across an issue where you can bring up the backup dialog but not the restore dialog, try making a backup of the database in question, then attempt to bring up the restore dialog again.

Tags: SSMS

Add a Comment

No Comments