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:


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?

  • What does select session_id, status, command, percent_complete from sys.dm_exec_requests where status in ('rollback', 'running', 'runnable') and session_id <> @@SPID return? Apr 4, 2023 at 21:31


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.