Event 1000
slhuillier.om
Posts: 7
On friday, our backup server rebooted by itself (!!!). Ever since, we cannot restore backups from our production server (the two work together with "log shipping" implemented through sql bu v3).
The event log on the backup server reports the following errors :
Event Id 1000 Category (1000)
Faulting application sqlbackupc.exe, version 3.2.0.5, faulting module kernel32.dll, version 5.2.3790.1830, fault address 0x00015dea.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
followed by Dr Watson's:
Event id 4097
Faulting application sqlbackupc.exe, version 3.2.0.5, faulting module kernel32.dll, version 5.2.3790.1830, fault address 0x00015dea.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
When we try restoring using the sqlbu interface, everything works fine. However, the job which uses the following TSQL (
master..sqlbackup '-SQL "RESTORE LOG [MAEVA3] FROM DISK = ''M:\SQLBU\CALCIUM\MAEVA3\TRANLOG\LOG*.sqb'' WITH STANDBY = ''M:\SQLBU\LOCAL\MAEVA3\UNDO\UNDO_MAEVA3.DAT'', PASSWORD = ''<ENCRYPTEDPASSWORD>****=</ENCRYPTEDPASSWORD>'', MOVETO = ''M:\SQLBU\LOCAL\MAEVA3\DONE\TRANLOG\''" -E'
) generates the error in the logs.
Thank you for your help!
The event log on the backup server reports the following errors :
Event Id 1000 Category (1000)
Faulting application sqlbackupc.exe, version 3.2.0.5, faulting module kernel32.dll, version 5.2.3790.1830, fault address 0x00015dea.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
followed by Dr Watson's:
Event id 4097
Faulting application sqlbackupc.exe, version 3.2.0.5, faulting module kernel32.dll, version 5.2.3790.1830, fault address 0x00015dea.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
When we try restoring using the sqlbu interface, everything works fine. However, the job which uses the following TSQL (
master..sqlbackup '-SQL "RESTORE LOG [MAEVA3] FROM DISK = ''M:\SQLBU\CALCIUM\MAEVA3\TRANLOG\LOG*.sqb'' WITH STANDBY = ''M:\SQLBU\LOCAL\MAEVA3\UNDO\UNDO_MAEVA3.DAT'', PASSWORD = ''<ENCRYPTEDPASSWORD>****=</ENCRYPTEDPASSWORD>'', MOVETO = ''M:\SQLBU\LOCAL\MAEVA3\DONE\TRANLOG\''" -E'
) generates the error in the logs.
Thank you for your help!
Comments
There is a patch for version 3 that may help you. if you contact support via email we will pass you the download information.
However there is a new version of SQL Backup that resolves most application problems. You can get this by using the check for updates item in the version 3 user interface. I have checked your licence and you are eligible for version 4.
If you want a quick fix use the version 3 patch, then evaluate version 4 and upgrade.
Let me know how you get on.
Regards
Dan
Red Gate Software Ltd