Solved

Restore on a Sql database

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
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…
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…

706 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

12 Experts available now in Live!

Get 1:1 Help Now