title: How to rollback database when user abort process?
body: <p>I have createde a stored procedure such as:</p>
  
  <pre><code>CREATE PROCEDURE backupDB
  BEGIN
  ...
  exec('BACKUP DATABASE '+@targetDbName+' TO DISK = ''C:\ABC\'+@backupFileName+'.bak''')
  ...
  END
  </code></pre>
  
  <p>I would like to rollback database when user abort backup Database process. For example, I create a button named "Cancel" and when user click it, all process in procedure 'backupDB' will be rollolbacked.
  So, How can do it?
  I use MS SQL Server 2008 R2 and Visual studio 2013 with ASP.NET MVC 5.</p>
  
  <p>Thanks for your help.</p>