Solved

Restore on a Sql database

Posted on 2009-07-10
2
311 Views
Last Modified: 2012-05-07
I removed a database out of my Sql server that I shouldnt have. I deleted the database and the files, also the backup on the server. I have a tape backup of the database. i am trying to restore and i get this message. Below Any ideas?
Restore- MBCSERVER01 V-79-57344-33938 - 

An error occurred on a query to database RSI.

V-79-57344-33938 - Exclusive access could not be obtained because the database is in use.

Open in new window

0
Comment
Question by:m_burnett
2 Comments
 
LVL 41

Accepted Solution

by:
pcelba earned 500 total points
ID: 24825518
The error is occurring because there is an application or process which has a lock on the databases in question. SQL is preventing the restore from being performed as SQL cannot gain total access on the databases. You should see errors from SQL in the application log on your SQL server.

Determine what application or process is accessing the database and stop the process from running when you attempt the restore.

Another possible reason is here: http://seer.entsupport.symantec.com/docs/240054.htm
0
 
LVL 2

Expert Comment

by:pankaj000009
ID: 24826451
1.   Restart server.
2.   and restore database.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

863 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now