Forum Discussion

Jeff Schwartz's avatar
Jeff Schwartz
Copper Contributor
Nov 15, 2017

SQL Server Restore has to be hung - can I kill it?

Hi everyone,

I'm running into a non-urgent problem in a test region.  I was trying to restore a backup from a newly migrated database (using the azure data migration service), but it has to be hung.  It's been at 50% completion for the last 5 hours.  Is there any way for me to kill the restore?

Thanks,

Jeff

1 Reply

Sort By
  • Jeff Schwartz's avatar
    Jeff Schwartz
    Copper Contributor
    Nov 15, 2017

    My restore finished last night.  Apparently sys.dm_operation_status only shows percentages of 0, 50, and 100. 

    I'm still curious if there's a way to kill a process in azure sql.

    Tanks and have a nice day,

    Jeff

Resources