Error 9004 means an error occurred while processing the log for database, so it will not attach. Here are the steps that worked for me, starting with emergency mode.
SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2
Part 2 on SPARSE Columns in SQL Server 2008: how they are stored as one XML column, plus the main advantages and the limits you should know about.
SQL SERVER – 2008 – Introduction to SPARSE Columns
A quick introduction to SPARSE Columns in SQL Server 2008, which take almost no space for NULL and zero values. Learn the basics and the 100,000 column limit.
SQL SERVER – Find Space Used For Any Particular Table
Running out of drive space is a common reason SQL Server stops. sp_spaceused shows the Space Used by any table, with its row count and index size.
SQL SERVER – 2008 – Introduction to Row Compression
Row Compression in SQL Server 2008 stores zero and null values without using disk space. Check the savings first with sp_estimate_data_compression_savings.
SQL SERVER – 2008 – Introduction to New Feature of Backup Compression
SQL Server 2008 adds Backup Compression. I back up AdventureWorks with and without compression, compare file sizes and show how to turn it on at server level.
SQL SERVER – Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
The SQL Server 2008 Reporting Services Add-in for SharePoint (RC0) brings report viewing, subscriptions and report management into WSS 3.0 and SharePoint Server 2007.