How can we help you today? How can we help you today?

Process Exit Code -1073741787 and -1073741819

I couldn't find anything in BOL to match these error codes.
CmdExec from MSSQL2K job for backup gets -1073741787
Command = "C:\Program Files\Red Gate\SQL Backup\SqlBackupC.exe" -SQL "BACKUP DATABASE [master] TO DISK = '\\usunas03\MSS_DBBackup\USUDB04_MRR\Baseline\master\master_db_base1.sqb' WITH INIT, COMPRESSION = 1"

CmdExec from MSSQL2K job for restore gets -1073741819
Command="C:\Program Files\Red Gate\SQL Backup\SqlBackupC.exe" -SQL "RESTORE DATABASE [DbName] FROM DISK = '\\usunas03\MSS_DBBackup\USUDB09\DbName\PreMonthEnd\2005_09\DbName_db_pre1.sqb', DISK = '\\usunas03\MSS_DBBackup\USUDB09\DbName\PreMonthEnd\2005_09\DbName_db_pre2.sqb', DISK = '\\usunas03\MSS_DBBackup\USUDB09\DbName\PreMonthEnd\2005_09\DbName_db_pre3.sqb' WITH REPLACE" -E"

Am I missing anything for running SQLBackup from SQL job step?
gaffer
0

Comments

9 comments

  • petey
    These error codes appear to be from the OS (ACCESS_VIOLATION and STATUS_NONCONTINUABLE_EXCEPTION).

    Do you encounter the same error when you run the backup/restore from the command line?
    petey
    0
  • gaffer
    Ran restore directly from GUI with the following result:

    SQL Backup dialog box:

    Access violation at adress 005B07E5 in midule 'SQLBackup.exe'. Read of address 00000003.

    Database restored okay but Restore Wizard displays --- SQL Server messages --- line and nothing else; appears to be hung up showing only hourglass. Only way to close window is with Task Manager, end task.

    This has happened for the last 2 restores.

    Thanks -- Gary
    gaffer
    0
  • gaffer
    Ran 3rd restore using GUI and everything worked great. Got the SQL Server messages and a Close button
    gaffer
    0
  • petey
    What is the version of the command line (SQLBackupC.exe) and GUI (SQLBackup.exe) that you are using?

    Could you pls check the logs in the C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log folder, if there is any further information on the restores that failed earlier?
    petey
    0
  • gaffer
    SQLBackup.exe Ver 3.2.01

    SQLBackupC.exe Ver 3.2.01

    No logs created for failed restores, only for successful restore.
    gaffer
    0
  • gaffer
    But wait, there's more!! If you order now...

    Tried to open SQL Backup GUI to do a Help > About and received the following message:

    SQL Backup dialog box:
    Cannot perform this operation on a closed dataset.

    After click on OK, SQLB launches

    Help > About shows 3.2.0.1 and my serial number.
    gaffer
    0
  • petey
    Any errors in the vdi.log file (found in the SQL Server Log folder)?
    petey
    0
  • gaffer
    No entries in VDI.log, no log records in C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Data or \Log.

    SQL Job log entry:
    Backing up DbName (full database) to \\NASDevice\MSS_DBBackup\USUDB04_MRR\Baseline\DbName\DbName_db_base1.sqb, \\NASDevice\MSS_DBBackup\USUDB04_MRR\Baseline\DbName\DbName_db_base2.sqb, \\NASDevice\MSS_DBBackup\USUDB04_MRR\Baseline\DbName\DbName_db_base3.sqb ...

    Backup dat
    C:\Program Files\Common Files\System\Mapi\1033\NT>IF -1073741787 NEQ 0 GOTO ERREXIT

    C:\Program Files\Common Files\System\Mapi\1033\NT>EXIT 1
    gaffer
    0
  • petey
    I would suggest requesting from Red Gate support the latest patch for the 3.2 series.
    petey
    0

Add comment

Please sign in to leave a comment.