SQL backup GUI freezes when saving options in Windows 2003

paulnxweb

When changing options (ie backup location, email. log files) followed by SAVE, the backup gui freezes. I have tried this 8 times unsuccessfully Anyone know what's going on?

I am running Windows 2003. The application event log has the following entry:

"Hanging application SQLBackup.exe, version 4.5.0.704, hang module hungapp, version 0.0.0.0, hang address 0x00000000.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp."


* The application works well in two Windows 2000 environment (one is license and the other is trial). The Windows 2003 is trial but once it is working I will put in my 2nd license number


Also the crash monitor gave me the following dump:

operating system : Windows 2003 Service Pack 1 build 3790
system language : English
system up time : 5 days 22 hours
program up time : 4 minutes 30 seconds
processors : 2x Intel(R) Xeon(TM) CPU 2.80GHz
physical memory : 684/2048 MB (free/total)
free disk space : (C:) 22.78 GB
display mode : 800x600, 8 bit
process id : $c50
allocated memory : 9.69 MB
executable : SQLBackup.exe
exec. date/time : 2006-07-05 10:19
version : 4.5.0.704
madExcept version : 2.7g
exception message : The application seems to be frozen.

main thread ($760):
7c82ed54 ntdll.dll KiFastSystemCallRet
7c822122 ntdll.dll NtWaitForSingleObject
77e6baa2 kernel32.dll WaitForSingleObjectEx
77e6ba0d kernel32.dll WaitForSingleObject
74cd2e39 DBmsLPCn.dll ConnectionRead
005a1d2c SQLBackup.exe OLEDBAccess 3455 OpenOrExec
005a1dd6 SQLBackup.exe OLEDBAccess 3475 DoExecute
005a1f6e SQLBackup.exe OLEDBAccess 3504 TOLEDBCommand.Execute
0058caf1 SQLBackup.exe CRAccess 653 TCRRecordSet.ExecCommand
005a60aa SQLBackup.exe OLEDBAccess 5269 TOLEDBRecordSet.ExecCommand
0059489f SQLBackup.exe DBAccess 2603 TCustomDADataSet.InternalExecute
005b2de9 SQLBackup.exe MSAccess 2366 TCustomMSDataSet.InternalExecute
00594a10 SQLBackup.exe DBAccess 2639 TCustomDADataSet.Execute
0060b3bf SQLBackup.exe udm_Main 1994 TdmMain.ExecSQBUtils
00608904 SQLBackup.exe udm_Main 1427 TdmMain.SetSQBSettings
0066b9e8 SQLBackup.exe uOptions 397 TfrmOptions.SaveGeneralSettings
0066bfaa SQLBackup.exe uOptions 466 TfrmOptions.btnSaveClick
004a6374 SQLBackup.exe Controls TControl.Click
0049b8d0 SQLBackup.exe StdCtrls TButton.Click
0049b9c4 SQLBackup.exe StdCtrls TButton.CNCommand
004a61dc SQLBackup.exe Controls TControl.WndProc
004a923b SQLBackup.exe Controls TWinControl.WndProc
0049b794 SQLBackup.exe StdCtrls TButtonControl.WndProc
004e3e31 SQLBackup.exe TntControls 665 TWinControlTrap.WindowProc
004a5fac SQLBackup.exe Controls TControl.Perform
004a9373 SQLBackup.exe Controls DoControlMsg
004a9a2b SQLBackup.exe Controls TWinControl.WMCommand
004a61dc SQLBackup.exe Controls TControl.WndProc
004a923b SQLBackup.exe Controls TWinControl.WndProc
004a8eb8 SQLBackup.exe Controls TWinControl.MainWndProc
0045345c SQLBackup.exe Classes StdWndProc
7739d000 user32.dll SendMessageW
77395584 user32.dll CallWindowProcW
004e3c8c SQLBackup.exe TntControls 604 TWinControlTrap.DefWin32Proc
0045345c SQLBackup.exe Classes StdWndProc
773ad03a user32.dll CallWindowProcA
004a931f SQLBackup.exe Controls TWinControl.DefaultHandler
004a677c SQLBackup.exe Controls TControl.WMLButtonUp
004a61dc SQLBackup.exe Controls TControl.WndProc
004a923b SQLBackup.exe Controls TWinControl.WndProc
0049b794 SQLBackup.exe StdCtrls TButtonControl.WndProc
004e3e31 SQLBackup.exe TntControls 665 TWinControlTrap.WindowProc
004a8eb8 SQLBackup.exe Controls TWinControl.MainWndProc
0045345c SQLBackup.exe Classes StdWndProc
77395584 user32.dll CallWindowProcW
004e3a94 SQLBackup.exe TntControls 553 TWinControlTrap.Win32Proc
0045345c SQLBackup.exe Classes StdWndProc
7738e401 user32.dll DispatchMessageA
004c63ab SQLBackup.exe Forms TApplication.ProcessMessage
004c63e2 SQLBackup.exe Forms TApplication.HandleMessage
004c2f79 SQLBackup.exe Forms TCustomForm.ShowModal
0079a44e SQLBackup.exe uMain 1028 TfrmMain.actOptionsExecute
004527a7 SQLBackup.exe Classes TBasicAction.Execute
004b145d SQLBackup.exe ActnList TContainedAction.Execute
004b20ff SQLBackup.exe ActnList TCustomAction.Execute
0045267b SQLBackup.exe Classes TBasicActionLink.Execute
004a635d SQLBackup.exe Controls TControl.Click
0048819c SQLBackup.exe ComCtrls TToolButton.Click
004a67ca SQLBackup.exe Controls TControl.WMLButtonUp
004a61dc SQLBackup.exe Controls TControl.WndProc
004a923b SQLBackup.exe Controls TWinControl.WndProc
004a5fac SQLBackup.exe Controls TControl.Perform
004a8f9c SQLBackup.exe Controls GetControlAtPos
004a9034 SQLBackup.exe Controls TWinControl.ControlAtPos
004a5fac SQLBackup.exe Controls TControl.Perform
004a90d2 SQLBackup.exe Controls TWinControl.IsControlMouseMsg
004a91be SQLBackup.exe Controls TWinControl.WndProc
0048c429 SQLBackup.exe ComCtrls TToolBar.WndProc
004e3e31 SQLBackup.exe TntControls 665 TWinControlTrap.WindowProc
004a8eb8 SQLBackup.exe Controls TWinControl.MainWndProc
0045345c SQLBackup.exe Classes StdWndProc
77395584 user32.dll CallWindowProcW
004e3a94 SQLBackup.exe TntControls 553 TWinControlTrap.Win32Proc
0045345c SQLBackup.exe Classes StdWndProc
7738e401 user32.dll DispatchMessageA
004c63ab SQLBackup.exe Forms TApplication.ProcessMessage
004c63e2 SQLBackup.exe Forms TApplication.HandleMessage
004c6602 SQLBackup.exe Forms TApplication.Run
007a8a37 SQLBackup.exe SQLBackup 76 initialization

thread $834 (TWorkerThread):
7c82ed54 ntdll.dll KiFastSystemCallRet
7c822122 ntdll.dll NtWaitForSingleObject
77e6baa2 kernel32.dll WaitForSingleObjectEx
77e6ba0d kernel32.dll WaitForSingleObject
004f2ca7 SQLBackup.exe VirtualTrees 5129 TWorkerThread.Execute
0042e776 SQLBackup.exe madExcept HookedTThreadExecute
00451890 SQLBackup.exe Classes ThreadProc
00404fb4 SQLBackup.exe System ThreadWrapper
0042e70b SQLBackup.exe madExcept ThreadExceptFrame
>> created by main thread ($760) at:
004f2bee SQLBackup.exe VirtualTrees 5092 TWorkerThread.Create

thread $52c (TConnectionManager):
7c82ed54 ntdll.dll KiFastSystemCallRet
77392f35 user32.dll GetMessageA
0060f41f SQLBackup.exe u_ConnectionThreadManager 109 TConnectionManager.Execute
0042e776 SQLBackup.exe madExcept HookedTThreadExecute
00451890 SQLBackup.exe Classes ThreadProc
00404fb4 SQLBackup.exe System ThreadWrapper
0042e70b SQLBackup.exe madExcept ThreadExceptFrame
>> created by main thread ($760) at:
0060f268 SQLBackup.exe u_ConnectionThreadManager 44 TConnectionManager.Create

thread $d68 (TConnectionThread): <suspended>
7c82ed54 ntdll.dll KiFastSystemCallRet
7c822002 ntdll.dll NtSuspendThread
77e7586a kernel32.dll SuspendThread
00451c9d SQLBackup.exe Classes TThread.Suspend
0060eccd SQLBackup.exe u_ConnectionThread 320 TConnectionThread.Execute
0042e776 SQLBackup.exe madExcept HookedTThreadExecute
00451890 SQLBackup.exe Classes ThreadProc
00404fb4 SQLBackup.exe System ThreadWrapper
0042e70b SQLBackup.exe madExcept ThreadExceptFrame
>> created by main thread ($760) at:
0060e142 SQLBackup.exe u_ConnectionThread 100 TConnectionThread.Create

thread $a60 (TConnectionThread): <suspended>
77e6b5bb kernel32.dll
>> created by main thread ($760) at:
0060e142 SQLBackup.exe u_ConnectionThread 100 TConnectionThread.Create

thread $6e4 (TConnectionThread): <suspended>
77e6b5bb kernel32.dll
>> created by main thread ($760) at:
0060e142 SQLBackup.exe u_ConnectionThread 100 TConnectionThread.Create

thread $424 (TConnectionThread): <suspended>
77e6b5bb kernel32.dll
>> created by main thread ($760) at:
0060e142 SQLBackup.exe u_ConnectionThread 100 TConnectionThread.Create

thread $794 (TConnectionThread): <suspended>
77e6b5bb kernel32.dll
>> created by main thread ($760) at:
0060e142 SQLBackup.exe u_ConnectionThread 100 TConnectionThread.Create

thread $d50 (TConnectionThread): <suspended>
77e6b5bb kernel32.dll
>> created by main thread ($760) at:
0060e142 SQLBackup.exe u_ConnectionThread 100 TConnectionThread.Create

thread $350:
7c82ed54 ntdll.dll KiFastSystemCallRet
7c822112 ntdll.dll NtWaitForMultipleObjects
0042e70b SQLBackup.exe madExcept ThreadExceptFrame
>> created by thread $d68 (TConnectionThread) at:
71c5965c NETAPI32.dll Netbios

modules:
00400000 SQLBackup.exe 4.5.0.704 C:\Program Files\Red Gate\SQL Backup
02480000 SQLOLEDB.RLL 2000.86.1830.0 C:\Program Files\Common Files\System\Ole DB
4c850000 oledb32.dll 2.82.1830.0 C:\Program Files\Common Files\System\Ole DB
4dbb0000 OLEDB32R.DLL 2.82.1830.0 C:\Program Files\Common Files\System\Ole DB
4e250000 sqloledb.dll 2000.86.1830.0 C:\Program Files\Common Files\System\Ole DB
5e9a0000 olepro32.dll 5.2.3790.1830 C:\WINDOWS\system32
61200000 MSDATL3.dll 2.82.1830.0 C:\Program Files\Common Files\System\Ole DB
68000000 rsaenh.dll 5.2.3790.1830 C:\WINDOWS\system32
6d560000 DBNETLIB.DLL 2000.86.1830.0 C:\WINDOWS\system32
71b70000 uxtheme.dll 6.0.3790.1830 C:\WINDOWS\system32
71bb0000 wsock32.dll 5.2.3790.0 C:\WINDOWS\system32
71bc0000 rdpsnd.dll 5.2.3790.0 C:\WINDOWS\system32
71bf0000 WS2HELP.dll 5.2.3790.1830 C:\WINDOWS\system32
71c00000 WS2_32.dll 5.2.3790.1830 C:\WINDOWS\system32
71c40000 NETAPI32.dll 5.2.3790.1830 C:\WINDOWS\system32
71f60000 security.dll 5.2.3790.0 C:\WINDOWS\system32
73070000 winspool.drv 5.2.3790.1830 C:\WINDOWS\system32
73440000 RICHED32.DLL 5.2.3790.0 C:\WINDOWS\system32
74a50000 MSDART.DLL 2.82.1830.0 C:\WINDOWS\system32
74c40000 RICHED20.DLL 5.31.23.1224 C:\WINDOWS\system32
74cd0000 DBmsLPCn.dll 2000.80.2039.0 C:\WINDOWS\system32
76190000 MSASN1.dll 5.2.3790.1830 C:\WINDOWS\system32
761b0000 CRYPT32.dll 5.131.3790.1830 C:\WINDOWS\system32
762b0000 comdlg32.dll 6.0.3790.1830 C:\WINDOWS\system32
766f0000 ntdsapi.dll 5.2.3790.1830 C:\WINDOWS\system32
76920000 USERENV.dll 5.2.3790.1830 C:\WINDOWS\system32
76aa0000 winmm.dll 5.2.3790.1830 C:\WINDOWS\system32
76b70000 PSAPI.DLL 5.2.3790.1830 C:\WINDOWS\system32
76c90000 msv1_0.dll 5.2.3790.1830 C:\WINDOWS\system32
76cf0000 iphlpapi.dll 5.2.3790.1830 C:\WINDOWS\system32
76ed0000 DNSAPI.dll 5.2.3790.1830 C:\WINDOWS\system32
76f00000 wtsapi32.dll 5.2.3790.1830 C:\WINDOWS\system32
76f10000 WLDAP32.dll 5.2.3790.1830 C:\WINDOWS\system32
76f50000 SECUR32.dll 5.2.3790.1830 C:\WINDOWS\system32
77010000 COMRes.dll 2001.12.4720.0 C:\WINDOWS\system32
770e0000 SETUPAPI.dll 5.2.3790.1830 C:\WINDOWS\system32
771f0000 WINSTA.dll 5.2.3790.1830 C:\WINDOWS\system32
77210000 wininet.dll 6.0.3790.2564 C:\WINDOWS\system32
77380000 user32.dll 5.2.3790.1830 C:\WINDOWS\system32
77420000 comctl32.dll 6.0.3790.1830 C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.3790.1830_x-ww_7AE38CCF
77670000 ole32.dll 5.2.3790.2492 C:\WINDOWS\system32
777b0000 CLBCatQ.DLL 2001.12.4720.2492 C:\WINDOWS\system32
77b90000 version.dll 5.2.3790.1830 C:\WINDOWS\system32
77ba0000 msvcrt.dll 7.0.3790.1830 C:\WINDOWS\system32
77c00000 GDI32.dll 5.2.3790.2606 C:\WINDOWS\system32
77c50000 RPCRT4.dll 5.2.3790.1830 C:\WINDOWS\system32
77d00000 oleaut32.dll 5.2.3790.1830 C:\WINDOWS\system32
77da0000 SHLWAPI.dll 6.0.3790.2564 C:\WINDOWS\system32
77e40000 kernel32.dll 5.2.3790.1830 C:\WINDOWS\system32
77f50000 ADVAPI32.dll 5.2.3790.1830 C:\WINDOWS\system32
7c340000 MSVCR71.dll 7.10.3052.4 C:\WINDOWS\system32
7c800000 ntdll.dll 5.2.3790.1830 C:\WINDOWS\system32
7c8d0000 shell32.dll 6.0.3790.2534 C:\WINDOWS\system32

paulnxweb

Found my own answer. This is a permission issue with the registry key HKEY_LOCAL_MACHINE/Software/Red Gate as the Red Gate Backup Agent service user must have write permission to this key.

Also I originally had problems installing Red Gate Backup under windows 2003 (no problems under Win 2000) and was forced to run the service under local system and then later change to my own downgraded service user. This implies that if you create a dedicated user to run red gate, you must
1) make sure the user has permission to write to registry key HKEY_LOCAL_MACHINE/Software/Red Gate
2) make sure the redgate service user has write permission to the "red gate log directory" (also got burnt here previously)

Not aware if the above info is part of RedGate installation docs

HJoyce

Hi paulnxweb

Glad you found the solution.
To let you know this has been addressed in the next version of SQL Backup.

Regards,
Helen