SQLTeam.com | Weblogs | Forums

How to stop backup process



I have initiated SQL Server database backup through management studio, now i want to stop or cancel backup.
pls guide how can i stop backup.


I'm assuming that you went through the Tasks->Backup... process. Also, I'm using a SQL 2012 SSMS. In the lower left of the Back Up Database window (in the Progress section) there is a "Stop action now" message that you can click


Hi, Imughal

You can stop the backup process through SSMS, TSQL Query and also you can use the SQL Server Management Object to stop the backup process.
To know more follow the given link https://msdn.microsoft.com/en-us/library/ms180776.aspx#Top