Red Gate forums :: View topic - Unable to open backup file
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

Unable to open backup file

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
ritense



Joined: 21 Jun 2011
Posts: 1

PostPosted: Tue Jun 21, 2011 8:43 am    Post subject: Unable to open backup file Reply with quote

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?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Tue Jun 21, 2011 2:24 pm    Post subject: Reply with quote

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?
<http://www.red-gate.com/products/dba/sql-virtual-restore/>

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group