Problems with Backups

FredMorinFredMorin Posts: 9
The following line works with a NOT COMPRESSED MST Backup

but hangs with a compressed one

backupDB.RegisterForDataCompare(backupDBSource.ToConnectionProperties())

Since I will send the backup by email to clients, I need it to be small.

Is that a bug, a limit of the tool, or is there something else i need to do..

Thanks

ETA: I figured out a workaround using ICSharpCode.SharpZipLib to zip in unzip in my app before calling the code.

But I am still curious as to why it didn't work

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Fred,

    SQL Data Compare can read compressed files produced by our own SQL Backup software, but not Microsoft backups that have been compressed using ZIP, for instance.

    If this is a SQL Backup file, it might be worth noting that the backup reader process can take a bit of time, so in a few cases it has appeared to hang up but if you watched the process in Task Manager, you would see activity.
Sign In or Register to comment.