EzDevInfo.com

data-recovery interview questions

Top data-recovery frequently asked interview questions

Recover old website off waybackmachine [closed]

Is there a way to recover an entire website from the waybackmachine?

I have an old site that is archived but no longer have the website files to revive it again. Is there a way to recover the old data so I can get my long lost files back?


Source: (StackOverflow)

Visual studio lost current code on sudden crash

My visual studio 2010 crashed when some carelessness [bit of madness] mistakenly pressed start button and my Acer timeline got unstable. Two projects where open at the time, one in visual studio 2005 [I have both 2005 and 2010 installed]. Unfortunately I lost all the codes I had done at the time along with those coded even weeks before. Now the project files in both the solutions are those weeks older. Amazingly, the .aspx pages are intact and .cs files are gone.

What can be done to get the lost data? Help please.

Thanks.


Source: (StackOverflow)

Advertisements

Where does MySQL store database files on Windows and what is the name of the files

So I accidentally formatted my hard drive and re installed windows and forgot to backup an important database I had in my mySQL server. I'm trying to salvage files now using some software, but I don't know what to look for.

What is the path that the files are stored in, and what are the files named (what naming convention, or file extension should I look for?)

I believe my server was using MyISAM, but not 100% sure.

Any advice would be appreciated!


Source: (StackOverflow)

How to recover Git objects damaged by hard disk failure?

I have had a hard disk failure which resulted in some files of a Git repository getting damaged. When running git fsck --full I get the following output:

error: .git/objects/pack/pack-6863e0a0e4b4ded6090fac5d12eba6ca7346b19c.pack SHA1 checksum mismatch
error: index CRC mismatch for object 6c8cae4994b5ec7891ccb1527d30634997a978ee from .git/objects/pack/pack-6863e0a0e4b4ded6090fac5d12eba6ca7346b19c.pack at offset 97824129
error: inflate: data stream error (invalid code lengths set)
error: cannot unpack 6c8cae4994b5ec7891ccb1527d30634997a978ee from .git/objects/pack/pack-6863e0a0e4b4ded6090fac5d12eba6ca7346b19c.pack at offset 97824129
error: inflate: data stream error (invalid stored block lengths)
error: failed to read object 0dcf6723cc69cc7f91d4a7432d0f1a1f05e77eaa at offset 276988017 from .git/objects/pack/pack-6863e0a0e4b4ded6090fac5d12eba6ca7346b19c.pack
fatal: object 0dcf6723cc69cc7f91d4a7432d0f1a1f05e77eaa is corrupted

I have backups of the repository, but the only backup that includes the pack file has it already damaged. So I think that I have to find out a way to retrieve the single objects from different backups and somehow instruct Git to produce a new pack with only correct objects.

Can you please give me hints how to fix my repository?


Source: (StackOverflow)

undo changes to a stored procedure

I altered a stored procedure and unknowingly overwrote some changes that were made to it by another developer. Is there a way to undo the changes and get the old script back?

Unfortunately I do not have a backup of that database, so that option is ruled out.


Source: (StackOverflow)

How to recover database from MDF in SQL Server 2005?

I have an MDF file and no LDF files for a database created in MS SQL Server 2005. When I try to attach the MDF file to a different SQL Server, I get the following error message.

The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure.

I would like to accomplish any one of the following options:

  1. Attach the database without data loss (unlikely but would save me some time).
  2. Attach the database with data loss (whatever transactions were open are lost).
  3. Recover the schema only (no data) from the MDF file.

What SQL commands can I try to get my database going again?


Source: (StackOverflow)

Getting the last version of a deleted folder in subversion

I need to get the content of folder deleted from our repository long time ago

  • I still know the name of the folder
  • I don't know the revision in which it was deleted
  • I don't know the date when it was deleted
  • In the history of the parent directory there is no information (i.e., there is not comment mentioning that the folder is deleted)

svn log doesn't seem to help:

$ svn log deleted_folder
svn: 'deleted_folder' is not under version control

svn co also doesn't help

$ svn co URL/deleted_folder

How can I find out the last revision of the deleted folder?

EDIT: an option would be with brute force to check backwards for every revision but as there are more than 10K of them the option would be just for emergency. And I really feel that there definitely must be a better way.


Source: (StackOverflow)

C# - Reading free space bits on harddrive [duplicate]

Possible Duplicate:
How can I undelete a file using C#?

Ever since I recovered a document using a software called Undelete, that scans your free space and shows you what files are recoverable, I was curious on how to program this. Being a new programmer where would I look to begin to research this?

From an article:

When you search for a particular file that has been deleted, the Undelete software scans the hard drive for pointers that were deleted recently. It then uses these pointers to locate the exact location of the deleted file. Once it locates the deleted data, it just recovers the data using the information available. Once the file has been recovered completely, you can now access it like before.

How would I begin this with C#?


Source: (StackOverflow)

LVM-like snapshot on a normal block device [closed]

Skip to the question if not interested by the story

After an unfortunate lost of 2 disk on a 4 disk raid 5 array I got into some voodoo to take as much data back as I can.

The first drive giving signs of weaknesses was replaces, and during the rebuild (~80% through) the second drive failed on some dead sectors.

Long story short, now I have two drives (2 and 4) on a consistent state. One (3) is synced but with bad sectors in the middle. The last (1) is only part synced due to the rebuild process. Disks are 1.5 Tb for a total 4.1 Tb array.

After having trying all the read-only voodoo on the 234, 124 and the 1234 configurations I've been able to get a good portion of the important data. (Which is only 100 Gb on the 4.1 Tb whole.)

Now the next step is to try some file system (reiserfs) rebuild to see if I'm able to get more data. Theses operations are destructive. And I have three working disks setups on different states to try.

So to the question

Is there any way to make a snapshot of any kind of the md block device and work on this without altering the md device?

Some points:

  • No matters the performance, very slow is acceptable.

  • I have 2 * 2 Tb of storage on external temporary drives usable for the "changelog" of the snapshot.

  • I do not have enough storage to copy the whole device (md) to another place and make a lvm volume with it. (Nor the space to image each drive separately)

  • No need to be reliable in time, the snapshot will be deleted after data recovery (if any).

  • Well, I think it is clear: I only need to to stuff on the read only md and then throw the changes away.

Any ideas?

Thanks!


Source: (StackOverflow)

postgresql data recovery after multiply rows update

I am trying to retrieve data lost on wrong update query, using xlog and pg_xlogdump tool.

The query was the following:
update table set column1 =21 where column2 > column3 ( 1 condition was missed, so more rows were updated )

Example of 1 update record shown below. It starts with 1 update line and 5 insert lines. I wonder is there any way to find the number replaced with 21?

1) First line ( update) rel 1663/5880305/5880686 shows exactly the table I am looking for (5880305 oid of the db and 5880686 oid of the table) Also I have old backup and row with tuple 47275/8 there is the same row that was updated, with new tuple in updated version ( new tid : 293804/16 )

2) 4th line shows column1 update (11996103 is oid of that column ) , however I don't know how to find tuple 302/164 and how to retrieve the lost number

Thanks in advance.

rmgr: Heap        len (rec/tot):    163/  8391, tx:  692554090, lsn: 115/73F1D288, prev 115/73F1D240, bkp: 1000, desc: update: rel 1663/5880305/5880686; tid 47275/8 xmax 692554090 ; new tid 293804/16 xmax 0
backup bkp #0; rel 1663/5880305/5880686; fork: main; block: 47275; hole: offset: 228, length: 20

rmgr: Btree       len (rec/tot):     34/    66, tx:  692554090, lsn: 115/73F1F368, prev 115/73F1D288, bkp: 0000, desc: insert: rel 1663/5880305/11995979; tid 6587/293

rmgr: Btree       len (rec/tot):     34/    66, tx:  692554090, lsn: 115/73F1F3B0, prev 115/73F1F368, bkp: 0000, desc: insert: rel 1663/5880305/11996093; tid 6587/292

rmgr: Btree       len (rec/tot):     34/    66, tx:  692554090, lsn: 115/73F1F3F8, prev 115/73F1F3B0, bkp: 0000, desc: insert: rel 1663/5880305/11996103; tid 302/164

rmgr: Btree       len (rec/tot):     34/    66, tx:  692554090, lsn: 115/73F1F440, prev 115/73F1F3F8, bkp: 0000, desc: insert: rel 1663/5880305/11996135; tid 43502/2

rmgr: Btree       len (rec/tot):     34/    66, tx:  692554090, lsn: 115/73F1F488, prev 115/73F1F440, bkp: 0000, desc: insert: rel 1663/5880305/11996136; tid 1/2

Source: (StackOverflow)

How can I undelete a file using C#?

I'm trying to find some lost .jpg pictures. Here's a .bat file to setup a simplified version of my situation

md TestSetup
cd TestSetup
md a
cd a
echo "Can we find this later?" > a.abc
del a.abc
cd..
rd a

What code would be needed to open the text file again? I'm actually looking for .jpeg files that were treated in a similar manner

More details: I'm trying to recover picture files from a previous one-touch backup where the directories and files have been deleted and everything was saved in the backup with a single character name and every file has the same 3 letter extension. There is a current backup but they need to view the previous deleted ones (or at least the .jpg files).

Here's how I was trying to approach it: C# code


Source: (StackOverflow)

Is it possible to read the magnetic strength of an individual bit on hard drive by software?

I am creating a data-recovery software and I was wondering if there is any low-level access on a HDD, that reads out the actual strength of the magnetic field that is under the HDD's reader head?

With such a function, the securely-erased drives could be restored without lab equipment.


Source: (StackOverflow)

Recovering deleted Records

I have accdently deleted some rows in a table and did the commit too. Now I want to recover them.

The DB I'm using is Oracle 11g R2.

I used the following query to get deleted records:

SELECT * FROM MY_TABLE AS OF TIMESTAMP ('13-MAR-11 8:50:58','DD-MON-YY HH24: MI: SS')

But while executing it gives an error saying:

Error at Command Line:3 Column:75
Error report:
SQL Error: ORA-00907: missing right parenthesis
00907. 00000 -  "missing right parenthesis"
*Cause:    
*Action:

But I couldn't figure the problem in this queury.

Can anyone pls help?


Source: (StackOverflow)

how to restore postgresql DB without backup

Forgot to make a backup. Now I have harddrive with databases and new system with empty postgres. Can I somehow restore databases? by simple copy of files etc?


Source: (StackOverflow)

Recovery after wrong MySQL update query?

I made a wrong update query in my table.

I forgot to make an id field in the WHERE clause.

So that updated all my rows.

How to recover that?

I didn't have a backup....


Source: (StackOverflow)