Unable to open backup file

Compares and synchronizes SQL database content.

Unable to open backup file

Postby ritense » Tue Jun 21, 2011 7:43 am

I bought the PRO license, because I liked the feature to use SQL data compare on a SQL backup file directly. And that is only in the PRO license. However, now I can't get it to work with any backup file. I tried many different backup files and everytime I hit "compare now", it starts, but then after a few seconds, it stops with the message "unable to open backup file". No other message whatsoever, just that.

The strange thing is, when I open the BAK file, it immediately tells me the info in the start-screen. It shows me that the file contains a full backup, data and the correct database. But then, when I start comparing, it fails.

Can anybody tell me what I have to check to make SQL backup files work with SQL data compare PRO? Maybe specific security settings?
Posts: 1
Joined: Tue Jun 21, 2011 7:38 am

Postby Chris Auckland » Tue Jun 21, 2011 1:24 pm

Thanks for your post.

Does the error always happen at the same point with whatever backup file is used? If the backup is situated on a network share, my initial guess would be that there was some kind of network glitch that caused the connection to drop. there isn't anything in the tool to recover from a network outage, so this might be a possibility.

Would you be able to try using SQL Virtual Restore to mount the backup file?

This will probably give you better results, as it will allow you to compare the backup file as a live database, rather than the slightly more limited comparison you can do directly through SQL Data Compare backup reader.

I hope this helps.
Chris Auckland
Posts: 760
Joined: Tue Oct 24, 2006 1:12 pm
Location: Red Gate Software Ltd.

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests