Improve company productivity with a Business Account.Sign Up

x
?
Solved

Corrupt SQL Database

Posted on 2012-03-16
5
Medium Priority
?
226 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
  • 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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.

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

579 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