Can I Extract Database Scripts from Corrupted Backup?

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Can I Extract Database Scripts from Corrupted Backup?

Postby rlquigley » Fri Mar 29, 2013 10:36 pm

Will this product enable me to extract database scripts from a corrupted, TDE-enabled backup?
rlquigley
 
Posts: 1
Joined: Fri Mar 29, 2013 10:34 pm

Postby eddie davis » Mon Apr 01, 2013 11:57 am

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
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests