Today I had the strangest thing happen. I turned on my laptop and found my SQL Server Express (2005) service came up with one of the databases saying "restoring...". Nothing I did could make it go away (restarting the computer, restarting sql server, nothing). Also, there was nothing I could do in the tasks like detach the db. It just kept erroring saying the database was in the process of restoring. Finally after some Google searching I came across this ExpertsExchange question (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22875577.html).

The answer is to execute this sql:

RESTORE DATABASE [your database name] WITH RECOVERY

I'm going to have to look into what actually was going on but right now I've got stuff to do...