Today, we are not able to restore the database to another.
We are restoring the production DB PROD to the test DB TEST. On going from
Options -> Restore from Backup -> Selecting the backup -> Restore -> Typing the name of the Destination DB TEST and clicking on Restore, the process immediately clears the Uncompressing stage, goes to Restoring and finishes to successful within a matter of seconds. It took at least 4-5 minutes to uncompress and restore earlier. Also, even though the window says DB restored successfully, the DB is not restored.