Command line restore returns a 0 errorlevel on failure
I've found a problem using the command line restore. On this paritcular failure it returns a 0 error level which is meant to indicate a success.
I've pasted the results from the command prompt:
C:\Documents and Settings\jonathan>"C:\Program Files\Red Gate\SQL Backup\SqlBackupC.exe" -SQL "RESTORE DATABASE [TMAC] FROM DISK = 'D:\Rackspace Backups\DIFF_(local)_TMAC_20050915 230001.sqb' WITH STANDBY = 'D:\Rackspace Backups\UNDO_TMAC.DAT'" -E
SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005 Trial - 7 days remaining
Restoring database TMAC from "D:\Rackspace Backups\DIFF_(local)_TMAC_20050915 230001.sqb"
Msg 3136, Level 16, State 1, Server TMACBACKUP, Line 1
Cannot apply the backup on device 'SQLBACKUP_41222664' to database 'TMAC'.
Msg 3013, Level 16, State 1, Server TMACBACKUP, Line 1
RESTORE DATABASE is terminating abnormally.
C:\Documents and Settings\jonathan>echo %errorlevel%
Any ideas guys - you've got 7 days to impress me