So for anyone who might read this in future, this was resolved successfully.

I opened a support call with Microsoft and Mani from Bangalore was brilliant.

The correct sequence of events to...

I didn't know that table exists.

command = DBCC, status = suspended, wait_type = LOGMGR, percent_complete = 0

This doesn't look like anything is happening, even though the query says 'running'.

I'm not...

Thanks, Gail

Here are the recovery steps so far:

1. Created a new database with exactly the same name and file names as the problem database.

2. Detached that database, deleted its log...

No, as mentioned a few times now, there is no full backup. I ran this command:

BACKUP LOG database TO DISK='F:\Backup\database_Log.bak'

I think I might be the client in question on this post and I'm not a SQL programmer or system admin, hence the newbie mistakes.

Here is what happened:

1. The log...