Solved

Corrupt SQL Database

Posted on 2012-03-16
5
218 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 500 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
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…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

825 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