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

Copper Contributor

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

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