How to stop a SQL Server Database that is in a restore process

How to stop a SQL Server Database that is in a restore process
chenf18Asked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
What you mean?
You want to stop database or SQL Server?

If you want to stop restore process just get the process ID and kill the process.
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
ALTER DATABASE yourdbname RECOVER

should do the trick?

or do you mean remove from the list?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.