Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Restore on a Sql database

Posted on 2009-07-10
2
313 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 42

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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?
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

860 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