Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How to cancel the backup

Author  Topic 

manishkaushik
Starting Member

14 Posts

Posted - 2010-04-16 : 03:08:08
Hi guys,

I used this simple TSQL to backup by database,
backup database mydb to disk='D:\fun\backup.bak'

I would like to know, how can I cancel this on going backup from the TSQL command it self.




Thanks
Manish

Kristen
Test

22859 Posts

Posted - 2010-04-16 : 03:14:24
SQL won't "return" until the BACKUP has completed - so just cancel/abort the session/connection will terminate the backup.
Go to Top of Page
   

- Advertisement -