• Question: If you run this command

    RESTORE DATABASE databasename WITH RECOVERY

    after a RESTORE WITH NORECOVERY as shown in GilaMonster's post, the database will change to a normal state and you're ready to go.

    What happens if you run this command while a database is actually in the process of restoring? Is this a safe thing for the OP to try?