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
  • 704,970
  • 168
  • 1,303
  • 1,425
Jonathan
  • 977
  • 9
  • 20

1 Answers1

0

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

Community
  • 1
  • 1
Phong Vo
  • 1,066
  • 7
  • 15