Can I Extract Database Scripts from Corrupted Backup?

rlquigleyrlquigley Posts: 2
edited April 1, 2013 6:57AM in SQL Compare Previous Versions
Will this product enable me to extract database scripts from a corrupted, TDE-enabled backup?

Comments

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Hi Rlquigley,
    Thank you for your forum post.

    SQL Compare is able to compare a backup file with a live database, so in your scenario comparing the backup file with a new empty live database you maybe able to extract creation scripts for the database objects.

    Personally I have never tested a TDE enabled backup, let alone a corrupt TDE corrupt backup file. Providing the backup file reader within SQL Compare is able to read the corrupt backup file, you maybe able to extract the data you are seeking.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.