Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.
share|improve this question
    
what was the DBCC command that you ran? –  swasheck Nov 7 '12 at 20:10
    
DBCC CHECKDB ('mydb', REPAIR_ALLOW_DATA_LOSS); –  Ezi Nov 7 '12 at 20:15
    
outside of scripting out objects and data ("generate scripts" from ssms) to recreate the db, it seems like you're going to have to wait for that backup to download. hopefully it's not corrupt. –  swasheck Nov 7 '12 at 20:30
    
what is the scripting option.. I need the data from the backup till now. (the last good backup was last week). –  Ezi Nov 7 '12 at 20:35
    
show 6 more comments

1 Answer

up vote 0 down vote accepted

The answer is - as many of you replied in the comment's - that there is no way around a backup is the only way to go. and I did find a good backup and it was restored. that you all for the help.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.