I just figured it out. Thanks !

How do I go about copying the Event handler(s)? The event is an execution of a stored proc that takes in parameters to update the log table.....I need to...

Update: I took Gail's advice and moved tempdb to another drive and recycled SQL Server. The database in question was able to recover and I was able to...

Here is what was in the errorlog

08/31/2010 09:02:13,spid52,Unknown,The transaction log for database 'E_Y' is full. To find out why space in the log cannot be reused see the log_reuse_wait_desc column...

I think the cause is known - the database is using FULL recovery model

and the transaction logs have never been backed up. Only full database backups have been taken.

So.......you're saying that freeing up space on the drive will not do anything and that bouncing the server will not do anything? Which means that my only recourse is...

I can't connect to the database to issue the alter database command to add another file.

Does anyone think that recycling the SQL Server will help?

The SQL server errorlogs do not go back as far as the last restart of the server. There is a message indicating that the process has been active since...

The messages in the errorlog indicated that there was no space left on the disk, followed by the transaction log full message. This occurred two weeks ago. Additionally...

From sys.databases, state_desc = RECOVERY_PENDING

Leo,

I agree that backup log with truncate will likely not work for the reasons you stated. Works that way in Sybase, too. Autogrow is on for this log...

Since the drive filled up two weeks ago, no backups have happened and no additional data has been loaded.

My background is in Sybase where I was rarely scared...

Thanks everyone. Whoever set up this database made some big mistakes. From the older logs that I have seen, it appears that they had set up full db...