In Management Studio I want to restore to a point in time from an existing database. However, the databases that I can choose from in the drop down list don't include the one I want to choose. And oddly, there are databases in the list that have been deleted too.

I closed/re-opened Management Studio in hopes it would refresh but no such luck.

Anyone know what the deal is here?

up vote 3 down vote accepted

First of all, if you restored a database using a full database backup, but specified a new name for the new database, the drop down menu in the Restore Database dialog in SSMS will show the name from the original backup, not the new name you specified

Another situation when a database is not shown in the drop down menu in the Restore Database dialog is when no database backups have been made for the database

  • Ok, so let's say I took a backup of a database and restored it to a different computer and named it differently. Then if I wanted to restore to a point in time from there, I wouldn't be able to do it using SMSS because the drop down would show the original name but I imagine I could still do it from a script. Does that sound right? – BVernon Oct 7 '13 at 15:27
  • Yes, you can use the syntax given here technet.microsoft.com/en-us/library/ms179451(v=sql.105).aspx Please note that the database name in the RESTORE DATABASE is the new database name (not the original one) – Milena Petrovic Oct 8 '13 at 9:09
  • "Another situation when a database is not shown in the drop down menu in the Restore Database dialog is when no database backups have been made for the database" - thank you so much! – Blakomen Sep 1 '15 at 14:57

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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