Restore process is hung up

I really could use help ASAP -

I started a restore process about 20 hours ago of a very SMALL database. It apparently is hung up because it is still in the "restoring" state. How can I stop the restore process? I need to get this database back up, even if it is to the state prior to attempting a restore. I can't do anything with it now because it keeps saying the database is in the middle of a restore. ANYONE? I can't find any way to kill the process or anything.

Any help would be GREATLY appreciated!

You can probably issue a RESTORE WITH RECOVERY to get in out of the restoring state. i.e.,

RESTORE DATABASE <dbname> WITH RECOVERY

|||Thanks. What I ended up doing was creating a new database and doing a restore to it and it worked fine. Then just deleted the one that was hung up.|||When it happens again then best you can check the event viewer logs for any issues on hardware.