Red Gate forums :: View topic - Slightly Different Error on Comparing Backup to Live DB
Return to www.red-gate.com RSS Feed Available

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

Slightly Different Error on Comparing Backup to Live DB

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
PaulTarka



Joined: 05 Oct 2012
Posts: 4

PostPosted: Fri Oct 05, 2012 9:11 pm    Post subject: Slightly Different Error on Comparing Backup to Live DB Reply with quote

Hello,

I'm having an issue comparing a non-encrypted backup to a live DB.

The software being used:

SQL Backup 7.2.1.4
SQL Data Compare 10.2.0.885

I can make a backup with no encryption and either minimum or maximum compression (both exhibit the same behavior). This backup can be restored just fine. When I try to compare this backup with the live database of which the backup was taken, I receive a "A duplicate object name has been found. This may occur if the SQL Server that you are registering is case sensivtive but the case sensitive option is not set."

I'm not sure which options need to be checked where to get this to work. I've recently installed all my software on this new laptop. I've never encountered this error on my previous laptop.

Any suggestions will be very welcome. Thanks.

Interesting bits of the logfile:
Code:

16:07:54.893|Trace  |Source Control Link |14 |SQL Source control link successfully created
16:07:54.943|Info   |SQL Compare Engine  |16 |Failed to find another AppDomain citizen that provided System.Data.SQLite, Version=1.0.54.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, let's load our version
System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.SQLite, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The system cannot find the file specified.
File name: 'System.Data.SQLite, PublicKeyToken=db937bc2d44ff139'
   at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
   at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
   at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
   at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
   at System.Reflection.Assembly.Load(String assemblyString)
   at #Cvg.#VOA.OnCurrentDomainAssemblyResolve(Object #Zsf, ResolveEventArgs #ead)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

16:07:54.943|Info   |SQL Compare Engine  |16 |Trying to load System.Data.SQLite, Version=1.0.54.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139 by probing C:\Program Files (x86)\Red Gate\SQL Data Compare 10\SQLite\System.Data.SQLite.dll
16:07:54.953|Info   |SQL Compare Engine  |16 |Remembered which version of System.Data.SQLite is in use: System.Data.SQLite, Version=1.0.54.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139
16:07:54.953|Info   |SQL Compare Engine  |16 |We loaded System.Data.SQLite, Version=1.0.54.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139 from C:\Program Files (x86)\Red Gate\SQL Data Compare 10\SQLite\System.Data.SQLite.dll
16:07:54.953|Info   |SQL Compare Engine  |16 |Loaded assembly System.Data.SQLite, Version=1.0.54.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139 from a file C:\Program Files (x86)\Red Gate\SQL Data Compare 10\SQLite
16:07:55.093|Trace  |Source Control Link |14 |SQL Source control link successfully created
16:07:55.293|Trace  |Source Control Link |14 |SQL Source control link successfully created
16:07:55.493|Trace  |Source Control Link |14 |SQL Source control link successfully created
16:07:55.593|Error  |SQL Compare Engine  |18 |SqlCompareException: A duplicate object name has been found. This may occur if the SQL Server that you are registering is case sensitive but the case sensitive option is not set.
System.ArgumentException: Unable to get PFS page for page ID 1:56460

Server stack trace:
   at #KSnb.#oTnb.#mXnb(#P2B #5Mrc)
   at #KSnb.#gUnb.#JUnb.#lBc()
   at #KSnb.#sUnb.#SUnb.#lBc()
   at #KSnb.#sUnb.#TUnb.#lBc()
   at #KSnb.#6Snb.#6Wnb(String #hvPb, IEnumerable`1 #tzPb, IEnumerable`1 #wsk)
   at #XSnb.#7Snb.#aXnb(String #hvPb, #1Snb #cNrc, #sUnb #rzPb)
   at #XSnb.#7Snb.#Deh(#kTnb #pxob, #9Rnb #WyL)
   at #jSmb.#0Rnb.#Mqv(IBackupSet #AMrc, Int32 #BMrc, Boolean #CMrc)
   at RedGate.BackupReader.BackupConnection.#HdL(Boolean #uMrc)
   at RedGate.BackupReader.BackupConnection.#xt()
   at #Cvg.#Vvg.#N9f(#YUU #I2O)
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
   at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
   at #Cvg.#Vvg.#Wvg.EndInvoke(IAsyncResult result)
   at #Cvg.#Vvg.#xoh()
   at #Cvg.#Vvg.#xAh()
   at #8rg.#Ssg.#Clh()
   at #8rg.#Ssg.#wlh()
16:07:55.703|Trace  |Source Control Link |16 |SQL Source control link successfully created
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Mon Oct 08, 2012 10:55 am    Post subject: Reply with quote

This is the same error with the PFS page that you get when comparing to encrypted backups. I though it was only going to happen for encrypted backups, but it looks like comparing SQL Backup files is completely broken.
(see also http://www.red-gate.com/MessageBoard/viewtopic.php?t=15847 )

You'll probably have to restore the database to compare it until this issue is resolved.
Back to top
View user's profile Send private message
PaulTarka



Joined: 05 Oct 2012
Posts: 4

PostPosted: Mon Oct 08, 2012 2:46 pm    Post subject: Reply with quote

I will keep an eye out for an update. Thanks for the reply.
Back to top
View user's profile Send private message
chujanen



Joined: 28 Dec 2012
Posts: 2

PostPosted: Fri Dec 28, 2012 10:58 pm    Post subject: Still an issue Reply with quote

I have been having problems with this repeatedly since SQL Backup v7. I am very frustrated.

When will this issue be fixed?
Back to top
View user's profile Send private message
thomaso



Joined: 26 Oct 2012
Posts: 2

PostPosted: Wed Jan 30, 2013 5:16 pm    Post subject: Reply with quote

I am having the same problem. I have backups that are both compressed and not compressed and I get the error "A duplicate object name has been found...." I don't receive this error when I do a compare with a standard backup from SSMS.

I have the latest updates to both Redgate SQL Backup (7.2.1.4) and Redgate SQL Data Compare (10.2.3.5) as of 30Jan2013.
_________________
Stop thinking like a developer and start thinking like your customers.
Back to top
View user's profile Send private message
PaulTarka



Joined: 05 Oct 2012
Posts: 4

PostPosted: Wed Feb 27, 2013 3:37 pm    Post subject: Still an issue Reply with quote

Any word on when this issue might be addressed?
Back to top
View user's profile Send private message
PaulTarka



Joined: 05 Oct 2012
Posts: 4

PostPosted: Tue Jan 14, 2014 4:40 pm    Post subject: Updates? Reply with quote

It has been well over a year since the initial problem was submitted and the issue still exists. Can we ever expect a fix for this issue?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Thu Jan 16, 2014 9:14 am    Post subject: Reply with quote

I'm sorry to say the work on the BackupReader DLL has been delayed. The team are working on 2014 support and some other pressing issues, and since there is a workaround, which is to restore the database to a SQL Server, it's been put on hold for a few more months. Sorry for the aggravation this is causing everyone.
Back to top
View user's profile Send private message
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