open a database that is in restoring state (useful when applying diffs or transactional but you change your mind and you want to open the db for business).

RESTORE DATABASE DatabaseName WITH RECOVERY