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!