PaulTarka
Joined: 05 Oct 2012
Posts: 3
|
 Posted: Fri Oct 05, 2012 9:11 pm Post subject: Slightly Different Error on Comparing Backup to Live DB |
 |
|
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 |
|
|
