Re: Exclusive Access could not be obtained during database restore

#1

Go to the server in Query Analyzer and issue

Exec sp_who2

You will see who is in the database

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"John" <jeetrana (AT) yahoo (DOT) com> wrote

Quote:

Hi,

I keep getting this error while trying to restore the
database:

"Exclusive Access could not be obtained because the
database is in use. RESTORE database is terminating
abnormally."

I am sure though that noone has logged onto the system
while I doing the restore but I keep getting this error.

Any clue?

Thanks.

#2

John,

I answered this on someother newsgroup.Please dont multipost.If you really
want to include more newsgroups please do so in a single post rather than
wasting other's time when the question is already answered elsewhere.

Thanks!
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

"John" <jeetrana (AT) yahoo (DOT) com> wrote

Quote:

Hi,

I keep getting this error while trying to restore the
database:

"Exclusive Access could not be obtained because the
database is in use. RESTORE database is terminating
abnormally."

I am sure though that noone has logged onto the system
while I doing the restore but I keep getting this error.

Any clue?

Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Exclusive Access could not be obtained during database restore

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: Exclusive Access could not be obtained during database restore - 06-30-2003 , 08:42 AM

Re: Exclusive Access could not be obtained during database restore - 06-30-2003 , 08:58 AM