April 17, 2015 at 5:55 am
Hi Experts,
Does anyone have any ideas how I can fix / repair a corrupted database that hangs when I run dbcheck? It hangs at 90%. I aslo tried to copy it from the hard drive but it hangs at 90% percent as well.
I'm running SQL Server 2005 SP4. I also have not backups. I know that is not very smart but it happened and now trying to get out of it.
April 17, 2015 at 6:07 am
URLT.
Start by informing the owners and users of the database that there's a good chance that data has been lost, if not the entire DB and that they should expect some downtime.
What errors are you getting?
What do you mean by 'hangs' when you refer to CheckDB?
What is the EXACT output of the following command
DBCC CheckDB('<Database name>') WITH NO_INFOMSGS, ALL_ERRORMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 17, 2015 at 8:22 am
I aslo tried to copy it from the hard drive but it hangs at 90% percent as well.
When you say that do you mean when you try to copy the mdf files in windows to another drive? If so that sounds like a corrupted harddrive, you can try to recover it but you could be very out of luck.
April 20, 2015 at 5:47 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply