In SSMS 2005, I want to use the GUI to copy a database by restoring in to a new database. I was using the "From database" radio button for the source, but then the databases in the list disappeared recently. I read the sql server documentation and it says that only databases that are on record as having a backup will show up in this list. Nothing in the documentation says whether this backup will the actual data source or not.
When I select "From Database" in the source options, does it pull from the most recent backup of the database, or the actual live database?