CODEWITHSUNDEEP
sql-servert-sql
Nodja
Nodja

Reputation: 139

How to handle multiple errors

When I run something like 

BACKUP LOG [somedb] 
TO DISK = N'i:\log.bak';

It throws 2 errors messages:

Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'i:\log.bak'. Operating system error 3(The system cannot find    the path specified.).
Msg 3013, Level 16, State 1, Line 2
BACKUP LOG is terminating abnormally.

When I try to handle the error with a TRY CATCH the error returned is always 3013. This is a problem for me because I want to know if the backup failed due to lack of space, or if the drive isn't present, etc.

Using @@ERROR returns the same error number.

Is there any way to handle multiple error messages like these?

Upvotes: 3

Views: 1505

Answers (1)

marc_s
marc_s

Reputation: 754348

You need to inspect the Errors collection inside the SqlException:

catch(SqlException sqlEx)
{
    foreach(SqlError error in sqlEx.Errors)
    {
       int code = error.Number;
       string msg = error.Message;
    }
 }

You should get all error with all relevant details in the SqlException.Errors

Upvotes: 4

Related Questions