I have started a restore operation, in which backup file is in Backup Server. After an hour I cancelled the operation; in order to copy the file into the local server and start the operation again. But now after 5 hours session is in rollback state and also status is suspended. I could not restart the SQL service. (Although I think this could make the situation even worst) Also this command give me no info:
KILL session_id WITH STATUSONLY
How can I monitor the Rollback progress? It causes that the file remains in use. I do not know what is my next steps to do?