A production server got I/O disk error's I tried to fix it with dbcc but it got unexpected errors and crashed after a few minutes. so I took the file down and copied it over to a new machine.
I have no recent backup available fast, (its a online backup that takes very long to download).
File activation failure. The physical file name "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mydb_log.LDF" may be incorrect. The log cannot be rebuilt because the database was not cleanly shut down. DBCC results for 'mydb'. Msg 824, Level 24, State 2, Line 1 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:3724880; actual 0:0). It occurred during a read of page (1:3724880) in database ID 5 at offset 0x0000071aca0000 in file '\mydb.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. The emergency-mode repair failed.You must restore from backup.