Does Restore "From database" restore from the most recent backup of the database or the actual live database?
It will not pull from the live database. There is no SQL command for this (yet). It will give you a selection of recent backups you can pick from. You can only restore from a database snapshot and from a backup, not from a live database.