1 Reply by gary.hilton

  • gary.hilton
  • New member
  • Offline
  • Registered: 30-10-2010
  • Posts: 3

Re: Restore Problems

Hi - I am having problems restoring from a backup. I have had to reload Recorder (Stand alone version). I had backed up to an external drive.
I have reloaded Recorder and installed the update (6.15.4) and changed the location of the backup to match the location I saved the file to.

I am trying to restore from the backup file but get the following message after a few minutes. Any help would be appreciated.

Gary

date/time         : 2010-10-30, 21:13:14, 552ms
computer name     : OFFICE-PC
user name         : Gary
operating system  : Windows NT New Service Pack 2 build 6002
system language   : English
system up time    : 1 hour 31 minutes
program up time   : 1 minute 52 seconds
processors        : 2x Intel(R) Celeron(R) CPU        E1200  @ 1.60GHz
physical memory   : 1142/2048 MB (free/total)
free disk space   : (C:) 64.54 GB
display mode      : 1280x1024, 32 bit
process id        : $1378
allocated memory  : 48.74 MB
command line      : RecorderApp.exe /1377422
executable        : RecorderApp.exe
exec. date/time   : 2010-07-22 16:40
version           : 6.15.4.238
madExcept version : 2.7h
exception class   : EOleException
exception message : Cannot open database "NBNData" requested by the login. The login failed.

main thread ($9c0):
00561cea RecorderApp.exe ADODB                      TADOConnection.DoConnect
00517f85 RecorderApp.exe DB                         TCustomConnection.SetConnected
00517f40 RecorderApp.exe DB                         TCustomConnection.Open
00638754 RecorderApp.exe DatabaseAccessADO  260  +1 TdmDatabase.OpenDatabase
0063b1b6 RecorderApp.exe DatabaseAccessADO  848 +38 TdmDatabase.DoRestore
00a0ff84 RecorderApp.exe FormActions       1564 +16 TdmFormActions.actRestoreExecute
004527ab RecorderApp.exe Classes                    TBasicAction.Execute
004aea3d RecorderApp.exe ActnList                   TContainedAction.Execute
004af6df RecorderApp.exe ActnList                   TCustomAction.Execute
0045267f RecorderApp.exe Classes                    TBasicActionLink.Execute
004c325f RecorderApp.exe Menus                      TMenuItem.Click
004c4513 RecorderApp.exe Menus                      TMenu.DispatchCommand
004c52ca RecorderApp.exe Menus                      TPopupList.WndProc
004cf94c RecorderApp.exe Controls                   TWinControl.MainWndProc
004c5219 RecorderApp.exe Menus                      TPopupList.MainWndProc
00453460 RecorderApp.exe Classes                    StdWndProc
76df8b77 user32.dll                                 DispatchMessageA
004bc12b RecorderApp.exe Forms                      TApplication.ProcessMessage
004bc162 RecorderApp.exe Forms                      TApplication.HandleMessage
004bc392 RecorderApp.exe Forms                      TApplication.Run
00a33a20 RecorderApp.exe RecorderApp        375 +83 initialization
76efd0e7 kernel32.dll                               BaseThreadInitThunk

thread $868:
77b45e74 ntdll.dll                 KiFastSystemCallRet
77b4560e ntdll.dll                 NtWaitForMultipleObjects
76efa5d1 kernel32.dll              WaitForMultipleObjectsEx
76e00f87 user32.dll                MsgWaitForMultipleObjectsEx
76df7f55 user32.dll                MsgWaitForMultipleObjects
0042aba7 RecorderApp.exe madExcept ThreadExceptFrame
76efd0e7 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($9c0) at:
749c7f66 gdiplus.dll               

thread $1ec:
77b45e74 ntdll.dll                 KiFastSystemCallRet
77b450ae ntdll.dll                 NtRemoveIoCompletion
76efd118 kernel32.dll              GetQueuedCompletionStatus
0042aba7 RecorderApp.exe madExcept ThreadExceptFrame
76efd0e7 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($9c0) at:
774f5409 RPCRT4.dll               

thread $1168:
77b45e74 ntdll.dll     KiFastSystemCallRet
77b4560e ntdll.dll     NtWaitForMultipleObjects
76efd0e7 kernel32.dll  BaseThreadInitThunk

thread $1318:
77b45e74 ntdll.dll     KiFastSystemCallRet
77b4561e ntdll.dll     NtWaitForSingleObject
76ef987e kernel32.dll  WaitForSingleObjectEx
76ef97ed kernel32.dll  WaitForSingleObject
76efd0e7 kernel32.dll  BaseThreadInitThunk

modules:
00270000 C4DLL.DLL       1.0.0.1            C:\Program Files\Recorder 6
002e0000 MS5User.Dll     5.0.0.4            C:\Program Files\Recorder 6
00400000 RecorderApp.exe 6.15.4.238         C:\Program Files\Recorder 6
01e70000 ms5cnv.dll      5.0.0.10           C:\Program Files\Recorder 6
02780000 GOTOGR~1.OCX    2.0.0.16           C:\PROGRA~1\RECORD~1\Addins
06190000 GoToKey.ocx     6.0.1.10           C:\PROGRA~1\RECORD~1\Addins
063b0000 SHOWUN~1.OCX    6.0.0.13           C:\PROGRA~1\RECORD~1\Addins
065c0000 STDVAL~1.DLL    6.15.1.230         C:\PROGRA~1\RECORD~1\Addins
10000000 MS5.Dll         5.0.0.12           C:\Program Files\Recorder 6
670d0000 sqloledb.dll    6.0.6002.18005     C:\Program Files\Common Files\System\Ole DB
67180000 oledb32.dll     6.0.6001.18000     C:\Program Files\Common Files\System\Ole DB
68170000 msado15.dll     6.0.6002.18005     C:\Program Files\Common Files\System\ado
687e0000 odbcint.dll     6.0.6000.16386     C:\Windows\system32
68910000 odbc32.dll      6.0.6002.18005     C:\Windows\system32
689c0000 msadce.dll      6.0.6002.18005     C:\Program Files\Common Files\System\msadc
68aa0000 HHCtrl.ocx      6.0.6001.18000     C:\Windows\system32
69b10000 msxml4.dll      4.20.9876.0        c:\Windows\system32
6a0c0000 comsvcs.dll     2001.12.6932.18005 C:\Windows\system32
6dff0000 DBNETLIB.DLL    6.0.6001.18000     C:\Windows\system32
6e020000 MSDATL3.dll     6.0.6001.18000     C:\Program Files\Common Files\System\Ole DB
6fbb0000 OLEDB32R.DLL    6.0.6000.16386     C:\Program Files\Common Files\System\Ole DB
70fa0000 SHFolder.dll    6.0.6000.16386     C:\Windows\system32
71620000 dssenh.dll      6.0.6001.18000     C:\Windows\system32
716b0000 olepro32.dll    6.0.6002.18005     C:\Windows\system32
716f0000 msadcer.dll     6.0.6000.16386     C:\Program Files\Common Files\System\msadc
71810000 security.dll    6.0.6000.16386     C:\Windows\system32
725f0000 SQLOLEDB.RLL    6.0.6000.16386     C:\Program Files\Common Files\System\Ole DB
72e60000 winspool.drv    6.0.6002.18087     C:\Windows\system32
73900000 comctl32.dll    5.82.6002.18305    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.6002.18305_none_88f3a38569c2c436
745e0000 DBnmpNTw.dll    6.0.6000.16386     C:\Windows\system32
74640000 MSDART.DLL      6.0.6001.18000     C:\Windows\system32
746e0000 wsock32.dll     6.0.6001.18000     C:\Windows\system32
748d0000 ATL.DLL         3.5.2284.2         C:\Windows\system32
749b0000 gdiplus.dll     5.2.6002.18005     C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.0.6002.18005_none_9e50b396ca17ae07
74c40000 OLEACC.dll      7.0.6002.18155     C:\Windows\system32
74c80000 winmm.dll       6.0.6002.18005     C:\Windows\system32
74f00000 comctl32.dll    6.10.6002.18305    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.6002.18305_none_5cb72f2a088b0ed3
75200000 uxtheme.dll     6.0.6001.18000     C:\Windows\system32
75570000 schannel.dll    6.0.6002.18290     C:\Windows\system32
756f0000 rsaenh.dll      6.0.6002.18005     C:\Windows\system32
757d0000 msv1_0.dll      6.0.6002.18111     C:\Windows\system32
758b0000 version.dll     6.0.6002.18005     C:\Windows\system32
758f0000 credssp.dll     6.0.6001.18000     C:\Windows\system32
75900000 bcrypt.dll      6.0.6002.18005     C:\Windows\system32
75950000 ncrypt.dll      6.0.6002.18005     C:\Windows\system32
75ac0000 CRYPT32.dll     6.0.6002.18005     C:\Windows\system32
75bc0000 mpr.dll         6.0.6002.18005     C:\Windows\system32
75c00000 ntdsapi.dll     6.0.6001.18000     C:\Windows\system32
75c20000 MSASN1.dll      6.0.6002.18106     C:\Windows\system32
75c60000 DNSAPI.dll      6.0.6002.18005     C:\Windows\system32
75c90000 cryptdll.dll    6.0.6001.18000     C:\Windows\system32
75e80000 NETAPI32.dll    6.0.6002.18005     C:\Windows\system32
75f00000 SXS.DLL         6.0.6001.18000     C:\Windows\system32
76020000 Secur32.dll     6.0.6002.18051     C:\Windows\system32
76040000 USERENV.dll     6.0.6002.18005     C:\Windows\system32
76180000 PSAPI.DLL       6.0.6000.16386     C:\Windows\system32
76190000 urlmon.dll      8.0.6001.18975     C:\Windows\system32
762d0000 shell32.dll     6.0.6002.18287     C:\Windows\system32
76de0000 user32.dll      6.0.6002.18005     C:\Windows\system32
76e80000 WS2_32.dll      6.0.6001.18000     C:\Windows\system32
76eb0000 kernel32.dll    6.0.6002.18005     C:\Windows\system32
76f90000 USP10.dll       1.626.6002.18244   C:\Windows\system32
77010000 iertutil.dll    8.0.6001.18975     C:\Windows\system32
773c0000 SHLWAPI.dll     6.0.6002.18005     C:\Windows\system32
77420000 oleaut32.dll    6.0.6002.18005     C:\Windows\system32
774b0000 RPCRT4.dll      6.0.6002.18024     C:\Windows\system32
77580000 ADVAPI32.dll    6.0.6002.18005     C:\Windows\system32
77650000 WININET.dll     8.0.6001.18975     C:\Windows\system32
77740000 ole32.dll       6.0.6002.18277     C:\Windows\system32
77890000 WLDAP32.dll     6.0.6002.18005     C:\Windows\system32
778e0000 MSCTF.dll       6.0.6002.18005     C:\Windows\system32
779b0000 comdlg32.dll    6.0.6002.18005     C:\Windows\system32
77a30000 msvcrt.dll      7.0.6002.18005     C:\Windows\system32
77ae0000 ntdll.dll       6.0.6002.18005     C:\Windows\system32
77c10000 LPK.DLL         6.0.6002.18051     C:\Windows\system32
77c20000 NSI.dll         6.0.6001.18000     C:\Windows\system32
77c30000 Normaliz.dll    6.0.6000.16386     C:\Windows\system32
77c40000 IMM32.DLL       6.0.6002.18005     C:\Windows\system32
77c60000 CLBCatQ.DLL     2001.12.6931.18000 C:\Windows\system32
77cf0000 GDI32.dll       6.0.6002.18005     C:\Windows\system32

2 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Restore Problems

Gary,

Are you just copying the back-up to the exisiting NBNDAta location, if so that isn't enough for Recorder and more importantly SQL Server.

You need to use something like the SQL Management Studio to detach NBNData from SQL Server, then copy the back-up into place, then reattach NBNData to SQL Server - that should work, but note, I'm not a qualified Recorder Support, so I hope one of them will also respond

Craig Slawson
Staffordshire Ecological Record

ser's Website

3 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Restore Problems

Gary

As Craig say there are issues in both SQl Server and R6 about copying backup up files. However, the error message is leaving me bit puzzled. Can you confirm that after the reinstall Recorder 6 was running with the blank database as installed by default. Secondly, that the datbase you were  trying to  restore from was a 6.15 database and not an earlier version.

Have you got the SQL mangement tools installed ?.  If not you will probably need to install them before we can proceed further. they are on the 6.15 CD, but its not that obvious how to insatll them. If you need help with this let me know.


Mike

Mike Weideli

MikeWeideli's Website

4 Reply by gary.hilton

  • gary.hilton
  • New member
  • Offline
  • Registered: 30-10-2010
  • Posts: 3

Re: Restore Problems

Hi
Thanks for your replies, I have started again  - installed Recorder (6.14.4.a)  which is the version I have on CD. I have not yet upgraded to 6.15 as I did last time. I have also reinstalled sql server and installed SQL Management Studio from the Microsoft site.
Can you point me in the right direction from here?
Many Thanks
Gary

5 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Restore Problems

Open Mangagment Studio and connect to the SQL instance used by R6.  Expand  Datbases and them right click on NBNDATA. Choose Task/Restore/Database. Choose from Device. Click on the browse box (...). Choose backup media = file. Choose Add. Find your backup file . Click on OK. Tick the restore box next to the file details and click on OK. This shouls restore your database.  You should then be able to do another backup from within  Recorder. If you can't do this or have any other problems let me know.

It is important to have the same version of R6 loaded as you had when the R6 backup was taken.


Mike

Mike Weideli

MikeWeideli's Website

6 Reply by gary.hilton

  • gary.hilton
  • New member
  • Offline
  • Registered: 30-10-2010
  • Posts: 3

Re: Restore Problems

Hi Mike,
Thanks - I Upgraded to 6.15 which was where I was when I took the backup. Restored the database in Management studio with no problem. I Initially got an error "Cannot open database "NBNData" requested by the login."  when I tried to open Recorder but after poking about in management Studio discovered that I the NBNData database did not have an owner. So set that to NBNUser (is that right?) and it now works and all the data there. Phew!!

Many Thanks for your help
Gary

7 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Restore Problems

Hi Gary
The database owner should really be set to "sa" not NBNUser. I think the step you were probably missing in getting the restored database to connect would have been to run the following query against the database:

exec sp_change_users_login 'update_one', 'NBNUser', 'NBNUser'

This is because you had re-installed SQL Server so in effect you were restoring from a different server.

John van Breda
Biodiverse IT

johnvanbreda's Website