Sample Header Ad - 728x90

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