Corrupt SQL Database

I am running a donor program on a Windows Server 2008 box, running SQL2008. The primary database file now fails when I run the integrity check on it and we are starting to see errors. I tried to copy all of the DBF files to a standalone server to bring them up there and the main DBF file gave me an 0x80007405D error. I have an older backup and I am able to get into the system to export my critical data to reimport if I have to do a recovery from the backup, but is there any hope of recovering the current database file?
ronbeattyAsked:
Who is Participating?
 
QPRCommented:
You could try dbcc using repair_allow_data_loss but be aware you may lose some data integrity here.

If this doesn't work then you may be left with no option but to restore from backup and reimport the data back in
0
 
ronbeattyAuthor Commented:
Wound up not attempting to do a repair but instead restoring the database from a backup. I would still be interested in attempting to repair the old one if I could be assured it would not affect the current DB. If I could copy the file and move it to a different box I would make the attempt, but since it is corrupt it would not allow me to move the actual DB file. Thanks for your recommendation and suggestion but the determination from leadership was to do the restore.
0
 
QPRCommented:
Which was the second option I gave in my answer :)

Try dettaching the DB and then moving the mdf and ldf to a different server and try attaching it there if you still want to try ressurecting it
0
 
ronbeattyAuthor Commented:
This was the only option that I really had. Thanks for the advice. I couldn't copy it anywhere else.. copying failed due to the corruption.
0
 
ronbeattyAuthor Commented:
I did detach it and attempt to move it. All files but the actual mdf file would move. I suspect that the corruption caused me not to be able to copy it and move it anywhere.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.