IF UPPER(@optype) = 'DB'

BEGIN

BEGIN

SET @execmd = N'BACKUP DATABASE [' + @database + '] TO DISK = ''' + @backupfilename + '''' +

CASE WHEN @backupwith IS NULL THEN '' ELSE (' WITH ' + @backupwith) END

BEGIN TRY -- Incorrect syntax near 'TRY'

EXEC(@execmd)

EXEC(@execmd)

END TRY -- Incorrect syntax near 'T

BEGIN CATCH -- backup failure

BEGIN CATCH -- backup failure

SELECT @err = @@ERROR,@ret = @err

SELECT @errormsg = 'Full backup of database ' + @database + ' failed with error : ' + CAST(@err as varchar(10))

SELECT @errormsg = 'Full backup of database ' + @database + ' failed with error : ' + CAST(@err as varchar(10))

SET @output = SPACE(4) + '*** ' + @errormsg + ' ***'

IF @debug = 1 PRINT @output

IF @report = 1

BEGIN

IF @debug = 1 PRINT @output

IF @report = 1

BEGIN

IF @report = 1

BEGIN

BEGIN

EXEC sp_OAMethod @file,'WriteLine',NULL,@output

SET @output = SPACE(4) + 'Refer to SQL Error Log and NT Event Log for further details'

EXEC sp_OAMethod @file,'WriteLine',NULL,@output

EXEC sp_OAMethod @file,'WriteLine',NULL,''

END