Well that's great. I can no longer connect to SQL on my computer. At all.

We haven't successfully been able to put the database into the emergency state (and we've tried a few times--actually, as I think I mentioned, the guy above me tried only...

Correct, that's all that was done. I can't connect to the server (my system) at all. I can connect to others just fine.

SQL no longer loads after trying that.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by...

Antares: Trying a single_file_db will not go through as I'm prompted for the recovery of our log file, as well. That's why I switched over to sp_attach_db, as I could...

Both leave the database sitting at Restoring. I've yet to see anything marked as Suspect.

RECOVERY and NORECOVERY both give me the error pasted above.

I ended up temporarily moving the cms_Data and cms_Log files off of my desktop, and tried the RESTORE again (with RECOVERY, CONTINUE_ON_ERROR, and MOVE etc). I'm back to this again:

Msg...

That's okay!

I tried the RESTORE command with MOVE to get both cms_Data and cms_Log to a new location (my desktop). Both showed up. However, I still got the error previously...

I think I mentioned this before--I'm trying to restore this to my own computer first, just be sure a) that it works and b) that I don't wipe out any...

OH! Okay, my apologies--I misunderstood what we were trying to do. I located the files.

This is becoming quite interesting. The result:

File activation failure. The physical file name "D:\(folder)\cms_Log.LDF" may be...

Detaching works. Rebuilding does not.

Msg 5172, Level 16, State 15, Line 1

The header for file '(filename)' is not a valid database file header. The FILE SIZE property is incorrect.

The thing...

I'm not able to, either via drop-down selection or putting the database name into the query:

Msg 927, Level 14, State 2, Line 1

Database 'cms' cannot be opened. It is in...

The error in full:

10 percent processed.

20 percent processed.

30 percent processed.

40 percent processed.

50 percent processed.

60 percent processed.

70 percent processed.

80 percent processed.

90 percent processed.

Msg 3241, Level 16, State 37, Line 1

The media...

All we've really done:

RESTORE DATABASE cms FROM (file) WITH NORECOVERY

We get cut off at 90% with the first error I posted:

[...]

90 percent processed.

Msg 3183, Level 16, State 2, Line 1

RESTORE...