Comments
9 comments
-
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? -
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 -
Ran 3rd restore using GUI and everything worked great. Got the SQL Server messages and a Close button
-
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? -
SQLBackup.exe Ver 3.2.01
SQLBackupC.exe Ver 3.2.01
No logs created for failed restores, only for successful restore. -
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. -
Any errors in the vdi.log file (found in the SQL Server Log folder)?
-
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 -
I would suggest requesting from Red Gate support the latest patch for the 3.2 series.
Add comment
Please sign in to leave a comment.
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?