Using exitcodes / sql error codes in scripts

randyj

randyj Posts: 48

June 27, 2006 12:18PM edited June 27, 2006 5:17PM in SQL Backup Previous Versions

Could someone post an example of using exitcodes / sql error codes in a backup script ? I'm having difficulty with my syntax.

Thanks !

0 ·

Comments

petey Redgate › Posts: 2,358 New member

June 27, 2006 12:31PM

Example:

DECLARE @exitcode int 
DECLARE @sqlerrorcode int 

EXEC master..sqlbackup '-sql "BACKUP ..."', @exitcode OUTPUT, @sqlerrorcode OUTPUT 

IF &#40;@exitcode &lt;&gt; 0&#41; OR &#40;@sqlerrorcode &lt;&gt; 0&#41; 
BEGIN 
  RAISERROR &#40;'SQL Backup step failed: exit code %d, SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode&#41; 
END

Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8

0 ·

randyj Posts: 48

June 27, 2006 5:17PM

Thanks, Peter...
Just what I needed!

0 · Share on Twitter

Sign In or Register to comment.