title: Try .... Catch is not giving all the errors in T-SQL execution
body: <p>I am trying to restore a database from a backup using Try Catch block. In that I am using first restore file list and then restore backup using Move option. with Try ... Catch Block. Iam trying to catch those errors into a table with insert statement. In that table I am getting only one message...</p>
  
  <p><strong>Restore Filelist terminating abnormally</strong></p>
  
  <pre><code>ErrorNumber ErrorSeverity ErrorState  ErrorProcedure  ErrorLine  ErrorMessage
  ----------- ------------- ----------- --------------- ---------- ----------------------------------
  3013        16            1           NULL            1          RESTORE FILELIST is terminating abnormally..
  </code></pre>
  
  <p>but not the following message...</p>
  
  <pre><code>Msg 3201, Level 16, State 2, Line 1
  Cannot open backup device '\\SQLBKUP\SQL Server\SQLInstance\DEFAULT\XYZ_9389451.bak'. 
  Operating system error 2(The system cannot find the file specified.).
  </code></pre>
  
  <p>Any thoughts why I am NOT getting that error captured with the Catch Block?</p>