Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to restore to a point in time from a database that is already attached. When I try to do this using SMSS I cannot find the database I want in the dropdown list, but oddly it has a couple databases in the list that have been deleted.

I tried closing/reopening SMSS in hopes that it would refresh but no such luck.

Anyone know why the database is not showing up in the "From database:" drop down list?


If I try to restore a backup to a point in time then no backup sets appear for me to select. However, if I restore the backup to the most recent point in time and then restore the transaction log then I'm able to select a point in time when restoring the transaction log. But then when I query the database I find that it's still restored to the most recent point in time from the database backup rather than the time I selected for the transaction log.

How do I restore to a point in time? The backups are using the full backup model, but I'm not sure if I should be doing anything else as part of the backup to be able to restore to a point in time. Any advice would be greatly appreciated!

share|improve this question
What drop down are you referring to? – Shawn Melton Aug 26 '13 at 0:31
In Management Studio when you restore a database you have the option to restore from a database or from a device. The dropdown for restoring from a database is the one I'm referring to. – BVernon Aug 26 '13 at 8:11
Do you have permissions to restore a database? – Shawn Melton Aug 26 '13 at 13:55

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.