Activity overview
Latest activity by 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 / comments
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\M...
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. / comments
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 ...
SQLBackup.exe Ver 3.2.01
SQLBackupC.exe Ver 3.2.01
No logs created for failed restores, only for successful restore. / comments
SQLBackup.exe Ver 3.2.01
SQLBackupC.exe Ver 3.2.01
No logs created for failed restores, only for successful restore.
Ran 3rd restore using GUI and everything worked great. Got the SQL Server messages and a Close button / comments
Ran 3rd restore using GUI and everything worked great. Got the SQL Server messages and a Close button
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 / comments
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 R...
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 DATABAS...
I've done some testing and here's the results:
Test 1: Backing up a database that doesn't exist
Return Code = 1, SQL job fails
Test 2: Syntax error in .CMD file
Return Code = 0, Backup not run, SQL job completed with success
Test 3 - backup to existing file with no INIT
ReturnCode = 1, SQL job fails
This one was interesting:
Test 4 - Syntax error, run SqlBackupC.exe directly from SQL job step (CmdExec)
ReturnCode = 1, SQL job fails
It get even more interesting because I got the same error as the first one but this time the CMD returned a 1 and the SQL job failed.
Event Viewer, Application, Error message:
18210 :
BackupMedium::ReportIoError: write failure on backup device 'SQLBACKUP_182491517'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). / comments
I've done some testing and here's the results:
Test 1: Backing up a database that doesn't exist
Return Code = 1, SQL job fails
Test 2: Syntax error in .CMD file
Return Code = 0, Backup not run, S...
SQL Backup returned zero when it failed
Executing SQL Backup in CMD file from SQL job. Job history shows "Process Exit Code 0. The step succeeded."
Event Log shows "BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup ...