Copying data from DVD with bad sectors
Solution 1:
One or two bad sectors in the file will not appreciably degrade the file, assuming you can get it off the DVD in the first place.
Due to the way that the video encoding/decoding process works I would expect there to be (at worst) a second or two where the picture looks "odd" after the bad data but after that the video should recover and continue to play.
As you stated the key data is the header, so long as this data is intact (along with the majority of the file) then the file should be playable.
The software DVD Decrypter is able to ignore errors and carry on copying data from a disc, but its use is of dubious legality. If this is your own personally made DVD then you should be fine.
As DVD Decrypter facilitates the removal of copy restrictions, certain uses may be illegal under the United States Digital Millennium Copyright Act unless making copies which are covered under the Fair Use doctrine. In countries without similar laws there may not be any legal restrictions.
Solution 2:
Most standard utilites like Windows Explorer will halt at the first error and abort the copy. If the sector is truly bad you can't recover any data from it. So you can't get any data out of it. Assuming you can substitute the bad sector with all zeroes, it will likely still play in a standard DVD player but it might skip or degrade the quality of the video at that point.
I've used the free DVD Fab Decrypter just to copy scratched DVD's (these are non-commercial unencrypted home video DVDs) and it has worked for me in the past to salvage what is possible.