after executing a back up cmd (via query) how to kill it
0
votes
3
answers
524
views
I have a big database (150 GB) that needs a back up and I don't have space in current machine, so I am pointing it to the different box which has space. After executing the cmd, it is executing the query but taking long time, not showing stats also.
Query used:
backup database [DBName] to
disk = '\\Servername\H:\Backup7-7-2017\dbname.bak'
with copy_only, stats = 1
go
It is running for more than 5 minutes and no change on stats, and in destination folder the file is not created yet, so I am planning to go for manual backup from GUI. Now I want to kill this running backup as it is in suspended mode, when I checked in activity monitor.
Asked by Harris Hilton
(1 rep)
Jul 7, 2017, 03:00 PM
Last activity: Jul 9, 2017, 02:19 AM
Last activity: Jul 9, 2017, 02:19 AM