Our autoloader recently encountered a hardware error during a backup job. After clearing the error, we noticed that one of our Sql Server databases would not come back online after a reboot. The SQL Enterprise Manager shows the database in a "loading" state. When I try to view the properties of the database I get an error that says "Error 927: Database 'WFCDB' cannot be opened. It is in the middle of a restore." When I then click OK, I get another message that says "Could not get the Properties information". I think that the SQL Agent may have been working with this DB when the autoloader locked up. How can I restore this DB and/or get it back up and running? I have rebooted the server to no avail. I tried running a 'Restore' query I found in a knowledgebase technote, but that did not successfully run either.
Thanks for the help