SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


««12

Database Recovery from Log File Only Expand / Collapse
Author
Message
Posted Monday, November 09, 2009 1:16 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 18, 2010 1:41 PM
Points: 1,016, Visits: 3,759
Todd Williams-416222 (11/4/2009)
Thank you for your response.

This is not my database. It is someone's who contacted me for help with recovering after a HDD crash. They said their back up media was bad and nothing could be restored from it.

The log file they have is pretty large: ~1.8 GB, and I don't know how far it reaches into the past, but recovering something is probably better than recovering nothing at this point.

Can you advise me on how I might go about recovering what is in the log file?

Any assistance will be greatly appreciated.


i would find out what is meant the backup media is bad and HDD crash. one time i had a case with Symantec open for a month because my netbackup catalog on an old server was corrupt and i had trouble importing 5 year old backup tapes. it's a sybase backend and they had me run a few commands to clear out a table or two and then i was able to import my tapes. a few weeks ago i got an email about a bug in Netbackup that deletes catalog data but if you take the tapes out you can still import them manually and get your backups back


you can find 10 free HD recovery tools by googling and there are professional data recovery services that can recover data. I think the US Government standard for sensitive data is 5 passes of flipping the bits. For classifed data we had to take out the hard drive, take it apart and physically destroy the platters with wire brushes. been a long time but from what I read is that even if you flip every bit on a HD, you can still recover a lot of the data if you know what you're doing.
Post #816088
Posted Monday, November 23, 2009 9:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 7:10 AM
Points: 160, Visits: 1,847
http://www.vogon-international.com/

Not cheap - but if the data is valuable (and why would you have it otherwise)
Post #823356
« Prev Topic | Next Topic »

««12

Permissions Expand / Collapse