What are the challenges you face when working across database platforms? Take the survey
Options

Event 1000

slhuillier.omslhuillier.om Posts: 7
edited February 27, 2006 12:50PM in SQL Backup Previous Versions
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!

Comments

  • Options
    Hi

    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
    Daniel Handley
    Red Gate Software Ltd
Sign In or Register to comment.