All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 8 posts ] 
Author Message
 Post subject: FILE MDF repair
PostPosted: October 24th, 2008, 9:03 
Offline
User avatar

Joined: October 14th, 2005, 9:26
Posts: 1029
Hi to all!

I have this file to repair and it I have in a good result of the repair, open in file with winhex and perceived that from page 2.374.735 it has in it date ties end 82098334, this file was copied by the customer before hd burning heads….

This file cannot be recovered…?


Attachments:
MDF WIN.JPG
MDF WIN.JPG [ 135.84 KiB | Viewed 5423 times ]

_________________
Нет ничего невозможного
Top
 Profile  
 
 Post subject: Re: FILE MDF repair
PostPosted: October 24th, 2008, 11:51 
Offline

Joined: October 21st, 2005, 0:45
Posts: 1516
Location: Mexico
Hello sempre
Like u can see the file doesnt has code "sectors" u need to find why, maybe that zone its damaged and the system jump that sectors (head)

Regards


Top
 Profile  
 
 Post subject: Re: FILE MDF repair
PostPosted: October 24th, 2008, 16:36 
Offline

Joined: June 28th, 2008, 0:37
Posts: 225
Location: San Francisco Bay Area www.harddiskcrashed.com
My question is what happened to the companion LDF?

If this is a SQL MDF and you have a companion LDF, you can do some magic. If it was ever backed up and you have an intact LDF for the period from last backup, you can recover it to the point of failure using that ancient backup.


Top
 Profile  
 
 Post subject: Re: FILE MDF repair
PostPosted: October 25th, 2008, 7:32 
Offline
User avatar

Joined: October 14th, 2005, 9:26
Posts: 1029
wiseleo wrote:
My question is what happened to the companion LDF?

If this is a SQL MDF and you have a companion LDF, you can do some magic. If it was ever backed up and you have an intact LDF for the period from last backup, you can recover it to the point of failure using that ancient backup.



Yes file SQL, yes file LDF, no backups!! :cry:

_________________
Нет ничего невозможного


Top
 Profile  
 
 Post subject: Re: FILE MDF repair
PostPosted: October 25th, 2008, 7:33 
Offline
User avatar

Joined: October 14th, 2005, 9:26
Posts: 1029
beto wrote:
Hello sempre
Like u can see the file doesnt has code "sectors" u need to find why, maybe that zone its damaged and the system jump that sectors (head)

Regards


Thanks your reply! (Beto)

_________________
Нет ничего невозможного


Top
 Profile  
 
 Post subject: Re: FILE MDF repair
PostPosted: October 25th, 2008, 8:34 
Offline

Joined: June 28th, 2008, 0:37
Posts: 225
Location: San Francisco Bay Area www.harddiskcrashed.com
sempre wrote:
wiseleo wrote:
My question is what happened to the companion LDF?

If this is a SQL MDF and you have a companion LDF, you can do some magic. If it was ever backed up and you have an intact LDF for the period from last backup, you can recover it to the point of failure using that ancient backup.



Yes file SQL, yes file LDF, no backups!! :cry:


OK, if the LDF is intact and the MDF file was never backed up, that would explain why MDF does not have much data in it. SQL database files have pre-allocated empty space at the end. Do some research into SQL data recovery and you'll see why this makes sense. In this case, the lack of a backup is a good thing.

One thing you can try is to attempt to attach both the MDF and the LDF to a SQL server instance. Obviously you as a recovery professional would be working with copies, but for anyone else who finds this message in the future: ONLY WORK WITH COPIES OF THESE FILES. The LDF file changes when you attach it to an instance.


Top
 Profile  
 
 Post subject: Re: FILE MDF repair
PostPosted: October 25th, 2008, 8:56 
Offline
User avatar

Joined: October 14th, 2005, 9:26
Posts: 1029
wiseleo wrote:
sempre wrote:
wiseleo wrote:
My question is what happened to the companion LDF?

If this is a SQL MDF and you have a companion LDF, you can do some magic. If it was ever backed up and you have an intact LDF for the period from last backup, you can recover it to the point of failure using that ancient backup.



Yes file SQL, yes file LDF, no backups!! :cry:


OK, if the LDF is intact and the MDF file was never backed up, that would explain why MDF does not have much data in it. SQL database files have pre-allocated empty space at the end. Do some research into SQL data recovery and you'll see why this makes sense. In this case, the lack of a backup is a good thing.

One thing you can try is to attempt to attach both the MDF and the LDF to a SQL server instance. Obviously you as a recovery professional would be working with copies, but for anyone else who finds this message in the future: ONLY WORK WITH COPIES OF THESE FILES. The LDF file changes when you attach it to an instance.


Ok, already I used these tools to repair of file: Repair for Kernel, officerecovery2008, and outhers....

not recovered one of tables most important of database... :cry:

all help and well coming...

_________________
Нет ничего невозможного


Top
 Profile  
 
 Post subject: Re: FILE MDF repair
PostPosted: October 25th, 2008, 8:58 
Offline

Joined: June 28th, 2008, 0:37
Posts: 225
Location: San Francisco Bay Area www.harddiskcrashed.com
What happens if you try to attach to a SQL Server instance?

There shouldn't be a need to run recovery tools on this file.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: Google [Bot] and 43 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group