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

Posted on 2007-10-05
Medium Priority
Last Modified: 2010-05-07
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

Question by:Nakuru1234

Author Comment

ID: 20024610
This is the actual error message

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


Accepted Solution

bluebellgroup earned 2000 total points
ID: 20026510
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.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question