0

I have createde a stored procedure such as:

CREATE PROCEDURE backupDB
BEGIN
...
exec('BACKUP DATABASE '+@targetDbName+' TO DISK = ''C:\ABC\'+@backupFileName+'.bak''')
...
END

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.

Thanks for your help.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Jonathan
  • 1,017
  • 10
  • 21

1 Answers1

0

You can apply Transaction in C# code or inside your stored procedure.Transaction

Community
  • 1
  • 1
Phong Vo
  • 1,078
  • 7
  • 16