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

I have a SQL server Database that shows "<Database name>(Loading)...but I cannot be able to stop it. I tried to detach it but I got a message cannot be able to detach a Database that is in a restore mode...? Please help...TIA

Cheers!
V.
Nakuru1234Asked:
Who is Participating?
 
bluebellgroupConnect With a Mentor Commented:
Hi,
Were you trying to restore a database into the server?  What you've done is that you happened to leave your database nonoperational but able to restore additional transaction logs.

try RESTORE DATABASE [your database name] WITH RECOVERY
Just substitute your database name and the state of the database is changed an you can now go in and use it.

Hope it helps.
0
 
Nakuru1234Author Commented:
This is the actual error message

Error 927: Database 'CONTRACTS' cannot be opened. It is in the middle of a restore. TIA...

Cheers!
V.
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.