?
Solved

Corrupt SQL Database

Posted on 2012-03-16
5
Medium Priority
?
221 Views
Last Modified: 2012-04-03
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
Comment
Question by:ronbeatty
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 1500 total points
ID: 37731345
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
 

Author Comment

by:ronbeatty
ID: 37802667
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
 
LVL 29

Expert Comment

by:QPR
ID: 37803289
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
 

Author Closing Comment

by:ronbeatty
ID: 37803313
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
 

Author Comment

by:ronbeatty
ID: 37803317
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question