[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

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?
0
ronbeatty
Asked:
ronbeatty
  • 3
  • 2
1 Solution
 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now