March 6, 2006 at 8:36 am
Hi,
I have a database mdf and ldf files.
I have tried to restore database through "sp_attach_db" but such files contains some corrupted pages.
Is there any way to repair such pages ??
Because without repairing such pages such files will not be stored??
Pls help me to solve such problem??
Regards,
Amit
March 6, 2006 at 10:36 am
You normally can't repair pages without the database being online.
Do you have a backup of the database?
-SQLBill
March 7, 2006 at 8:11 am
Sorry ?
I do't have any backup ?
but i think it will not solve my problem??
Then What i have to do???
Regards,
Amit Gupta
March 7, 2006 at 10:12 am
If you had a backup, you would be able to restore from the backup file.
Looks like you are out of luck. Somehow your files got corrupted and are unusable. I don't know of any way to recover corrupted .mdf and .ldf files.
-SQLBill
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply