Guys, Recently i came across a situation where the log file of an SQL Server Std 2008 database got corrupt. i was unable to view the database properties and contents. I did the following: 1. Detach the corrupted database 2. Create a new Database with the same Name, and same data file name 3. Stop Sql Server service 4. Replace the new data file with the Old file 5. Start SQL Server 6. Database is started in Suspect Mode 7. Set the Databse in Emergency Mode 8. Set Database in Single User Mode 8. Run DBCC CheckDB Repair Allow Data Loss 9. ReStart SQL Server Service 10. Set the DB back to MultiUser Mode. Hope this helps.