<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Data Corruption
»
corrupted mdf file
11 posts, Page 1 of 2
1
2
»»
corrupted mdf file
Rate Topic
Display Mode
Topic Options
Author
Message
Ukon
Ukon
Posted Tuesday, March 15, 2011 3:29 PM
SSC Rookie
Group: General Forum Members
Last Login: Today @ 10:38 AM
Points: 36,
Visits: 101
hello: i was given a corrupted mdf file, the server the database (sql 2000) crashed and the only file recovered was this .mdf file. I have tried as many of the options that i can find, and still cannot get this database recovered. downloaded several of the programs that claim to be able to recover mdf files and none work.. This latest gives me the following error:SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0xd8b4c0f2). It occurred during a read of page (0:0) in database ID 0 at offset 0000000000000000 in file 'C:\DBIO\testy.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
I created a new database (sql 2008 r2) since I do not have sql 2000 anywhere. renamed the mdf file and then renamed the corrupted one to the new name and restarted. This then brings up the db in recovery_pending mode and I cannot get it out of that mode. Tried setting it to emergency mode, no luck. Is there anyway for me to recover this db?
No there were no backups of this database at all, and yes, i completely agree that a backup strategy is needed, but i'm just the lucky recipient of the issue :)
thank you for any help!
Post #1078689
GilaMonster
GilaMonster
Posted Tuesday, March 15, 2011 4:32 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:08 PM
Points: 38,099,
Visits: 30,392
Irreparable, nothing that can be done. The file header is damaged, SQL cannot open that file. Since it's the primary file of the database, SQL can't open the DB at all
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1078712
prettsons
prettsons
Posted Thursday, April 14, 2011 5:37 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 8:48 PM
Points: 100,
Visits: 1,105
If your database (mdf) get corrupt then you can recover it by updated backup..This is the best way to get back all your precious data. The another way to recover corrupt mdf files is use of good sql database recovery software. I will suggest you to try Stellar Phoenix SQL Database Recovery because I have already use this software & recover my database in 3 easy steps. First check its demo version from the site:
http://www.stellarsqldatabaserecovery.com/
If you find it useful then you can also purchase it.
SQL Database Recovery Expert
Post #1093417
stephencook2913
stephencook2913
Posted Saturday, April 14, 2012 4:10 AM
Forum Newbie
Group: General Forum Members
Last Login: Saturday, April 14, 2012 4:59 AM
Points: 2,
Visits: 6
SQL Database backup should be created and used in these corruption situations but as you mentioned you have not created any backup then you can try for some recovery tool that can help you. As a Genuine SQL user, i would like to suggest you a troubleshooting tool that will solve your corruption issue surely because it helped me to come out of some corruption situations. You can get more information from
http://www.sqldatabaserecovery.n.nu/
Post #1283609
avirasimon
avirasimon
Posted Sunday, June 24, 2012 2:40 AM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, June 24, 2012 2:27 AM
Points: 1,
Visits: 1
As we all are familiar with the point that DBCC commands are not able to remove all the problems observed in stored mdf file. User can perform
corrupt mdf fix
function with the third party tool which can work efficiently in all corruption cases.
Post #1320335
rodyroon 12270
rodyroon 12270
Posted Tuesday, July 17, 2012 3:50 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, July 17, 2012 6:10 AM
Points: 1,
Visits: 1
The MDF files of SQL database may get corrupt due to some problem in the database. If such a situation arises, the user can use the software which recovers the lost MDF file. But before choosing the software, make sure that it is efficient enough to recover the unique keys, primary keys, indexes, stored procedures, views etc from your corrupt MDF file. one of the software which i used before want to suggest you it is Kernel for SQL Database Repair you can download this software from here
http://www.restoresqldatabase.org/
Post #1330609
zacharys
zacharys
Posted Sunday, August 12, 2012 9:33 PM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, August 16, 2012 5:28 AM
Points: 2,
Visits: 4
Yes, there are some data recovery software available for SQL data recovery. You can recover your mdf file easily.
Lost data on your computer? Accidentally deleted files but want to get them back? Formatted the hard drive withou backing up your data? Don't worry, data recovery software can help you out.
http://www.any-data-recovery.com
Post #1343960
mountainfalling
mountainfalling
Posted Saturday, August 18, 2012 6:56 AM
Forum Newbie
Group: General Forum Members
Last Login: Saturday, August 18, 2012 6:52 AM
Points: 1,
Visits: 0
Ukon (3/15/2011)
hello: i was given a corrupted mdf file, the server the database (sql 2000) crashed and the only file recovered was this .mdf file. I have tried as many of the options that i can find, and still cannot get this database recovered. downloaded several of the programs that claim to be able to recover mdf files and none work.. This latest gives me the following error:SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0xd8b4c0f2). It occurred during a read of page (0:0) in database ID 0 at offset 0000000000000000 in file 'C:\DBIO\testy.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
I created a new database (sql 2008 r2) since I do not have sql 2000 anywhere. renamed the mdf file and then renamed the corrupted one to the new name and restarted. This then brings up the db in recovery_pending mode and I cannot get it out of that mode. Tried setting it to emergency mode, no luck. Is there anyway for me to recover this db?
No there were no backups of this database at all, and yes, i completely agree that a backup strategy is needed, but i'm just the lucky recipient of the issue :)
thank you for any help!
If your SQL database has gone damaged, then the way to recover database goes through a backup. If you have a recent backup of the database elements, then recovery is possible. If you lack these, then you shall have to opt for a professional sql database recovery software.
You can read more about this on:
http://sqldatabase-recovery.com
Post #1346842
lilylisa083
lilylisa083
Posted Sunday, November 25, 2012 12:06 AM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, November 25, 2012 12:01 AM
Points: 1,
Visits: 4
zacharys (8/12/2012)
Yes, there are some data recovery software available for SQL data recovery. You can recover your mdf file easily.
Agree, a good data recovery software can be used for SQL data recovery. You can try to recover corrupted mdf file with data recovery software.
Need file recovery? Or hard drive data recovery software?
Recover deleted files Quickly and Easily
http://www.asoftech.com/adr/
Post #1388374
Your Name Here
Your Name Here
Posted Monday, November 26, 2012 10:13 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 12:31 PM
Points: 130,
Visits: 517
Sorry for the "Captain Obvious" fly-by but...
If you have the database at a point where it's barking about running DBCC CHECKDB, have you given that a shot? Let DBCC put the pieces together if it can. If it can't, well, you may be out of luck.
Regarding the "recovery software" I'd avoid getting my hopes up. I'm no expert but I believe most of this type of software is "file recovery" not "database recovery" so simply having a [copy] of a corrupted file won't be enough - you'll need to give the software access to the physical box (or drive) that crashed (read: the original drive will need to be available). Good luck and godspeed.
<my two cents>
If the database was on a server that is [several versions] out of mainstream support (did I get that math right? 2000, 2005, 2008, 2008 R2, 2012) I'd consider this recovery exercise to be directly related to the decision not to upgrade [12-year-old] software. I'd report the database to be irreparable and irrecoverable since you have no backup. This jab is .:[NOT]:. directed at you, but at the decision-makers that allow this situation to happen. There. I'm done ranting now. My apologies to all the gentle readers of SQLServerCentral.com. This stuff just fires me up. I wish you the best of luck.
</my two cents>
Post #1388712
« Prev Topic
|
Next Topic »
11 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
