• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

Restore on a Sql database

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

1 Solution
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
pankaj000009Software DeveloperCommented:
1.   Restart server.
2.   and restore database.
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.

Join & Write a Comment

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now