Re: Can not connect to Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 10/18/04 

Date: Mon, 18 Oct 2004 17:44:40 -0400

More than likely you have EM or QA pointing to it. In EM make sure you
click on an active node other than the db in question. Run sp_who2 or
sp_lock to see which spid is accessing the db. 

-- 
Andrew J. Kelly  SQL MVP
"Kevin" <Kevin@discussions.microsoft.com> wrote in message 
news:AE0CE4C0-2342-444E-8128-28795F6F1F7D@microsoft.com...
> I'm using SQL Server 2000
> I'm trying to store a database to a test database as I have done in the
> past, now I'm getting an error message saying "Exclusive access could not 
> be
> obtained because the database is in use. RESTORE DATABASE is terminating
> abnormally."
> No is using this test database. Could someone tell me what is causing this
> error and how can I solve this problem.
>
> Thank you in advance,
>

Relevant Pages

  • SqlServer 2005: How *best* to copy one database to another
    ... We would like to replace our test database with our production ... tables from our customer database in Management Studio. ... data but the identity fields were turned off as identities. ...
    (comp.databases.ms-sqlserver)
  • Re: Automate SQL Question
    ... I need to generate reports on one database (SQL statements developed to ... load them into a test database (control files ... I would tend to write a shell script and run it from cron. ...
    (comp.databases.oracle.tools)
  • Ora-19906 when restoring user managed backup - stumped!
    ... I have a test database I often restore from an online user managed backup, ... Looking up the 19906 error says its an rman incantation setting, but I am not using rman at all for this, and I'm stumped why this is happening now. ...
    (comp.databases.oracle.server)
  • Re: How can I delete one of two instances?
    ... Maybe just test with a test database on another pc... ... also think it may be easier that I make the change of SID permanently. ... Depends what you are deleting from. ...
    (comp.databases.oracle.server)
  • Re: oracle standby datase with select option
    ... I need to create test database like production database. ... solution for now is standby databse but it not good enough there is any ...
    (comp.databases.oracle.server)