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

Process Exit Code -1073741787 and -1073741819

gaffergaffer Posts: 10
edited November 22, 2005 11:13PM in SQL Backup Previous Versions
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?

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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
  • Options
    Ran 3rd restore using GUI and everything worked great. Got the SQL Server messages and a Close button
  • Options
    peteypetey Posts: 2,358 New member
    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?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    SQLBackup.exe Ver 3.2.01

    SQLBackupC.exe Ver 3.2.01

    No logs created for failed restores, only for successful restore.
  • Options
    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.
  • Options
    peteypetey Posts: 2,358 New member
    Any errors in the vdi.log file (found in the SQL Server Log folder)?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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
  • Options
    peteypetey Posts: 2,358 New member
    I would suggest requesting from Red Gate support the latest patch for the 3.2 series.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.