Re: Unable to load a database file

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 02/16/05


Date: Wed, 16 Feb 2005 23:51:02 +0100

run sp_who2 and see who is connected.

Might be SQL Agent.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Unable to load a database file" <Unable to load a database
file@discussions.microsoft.com> wrote in message
news:C25CE923-1DC5-492A-9D3D-112EAD0E40A8@microsoft.com...
> All,
>
> I need help with this. I am trying to restore a sql server database with a
> file from a vendor and I am getting this error message below. I am the
only
> person that is logged on to this database. Any ideas....
>
> Error:
> Microsfot SQL-DMO (ODBC SQLSTATE: 42000)
> Exclusive access could not be obtained because the databse is in use.
> Restore database is terminating abnormally.
>
>
>
>



Relevant Pages

  • Re: Profiling error message 208: sorting the wheat from the chaff
    ... Profile load to a file then load the> file to a table or have Proviler load to a table directly. ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: attaching DAT files
    ... use DUMP and LOAD, go for that. ... DUMP DATABASE ... > After REFIT stop and start SQL server service. ...
    (microsoft.public.sqlserver.connect)
  • Re: attaching DAT files
    ... use DUMP and LOAD, go for that. ... DUMP DATABASE ... > After REFIT stop and start SQL server service. ...
    (microsoft.public.sqlserver.server)
  • Re: attaching DAT files
    ... use DUMP and LOAD, go for that. ... DUMP DATABASE ... > After REFIT stop and start SQL server service. ...
    (microsoft.public.sqlserver)
  • Re: problem with query moving data from 1 dbase to another.
    ... You register a SQL Server instance, where such an instance can have several databases. ... Tibor Karaszi, SQL Server MVP ... > you know how to connect to an existing database, ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)