Comparing a database with a backup file

margiu

Do you have any example for comparing and synchronizing a database with a backup file??

Brian Donahue

There are some examples on the SDK wiki:

• Restore schema object from backup
• Compare live database data to a backup

margiu

Thanks Brian, but I've a problem with the example code "Compare live database data to a backup". In line 30
IList<IBackupSet> backupSets = backupDB.GetBackupSets(files, passwords);

SQLBackupReaderLoadException: Cannot load the Backup Reader dll!

Brian Donahue

Yep, probably should have mentioned that the BackupReader code is 32-bit only. Normally you can compile your SDK project as AnyCpu, but once you reference the Backup Reader you have to compile your code as x86 code.