Re: "exclusive access could not be obtained.." while restoring

From: Jim Young (thorium48_at_hotmail.com)
Date: 06/01/04

  • Next message: Jan Heinsen: "Re: Where to get a working download of MSDE" 
    Date: Tue, 1 Jun 2004 14:39:59 -0700

    While you are trying to do the restore, connect to the server and run the
    sp_who2 stored proc to see what users are connected to what database and
    what application they are using. This will at least give you an idea what
    processes are connected to your database.

    You could use the brute force method of running some T-SQL to kill all the
    connections that are using your database.

    Jim

    "newbie" <anonymous@discussions.microsoft.com> wrote in message
    news:FFCBF230-B3A1-4C1D-A542-B4B82C324F59@microsoft.com...
    > Jim I tried that, it didn't work either. I changed the initial catalog to
    master but still the same problem...
    >
    > what should I do.. please help.

  • Next message: Jan Heinsen: "Re: Where to get a working download of MSDE"

    Relevant Pages

    • Re: Simultaneous SQL queries to Access
      ... Jim ... >connections, or users already in the database will have ... training piece so that if the asp page returns an ...
      (microsoft.public.inetserver.asp.db)
    • Re: How can I open an SQL database and be the only one who has access to it?
      ... you can determine how SS permits access to your server. ... SINGLE_USER allows one user at a time to connect to the database. ... controlled by the termination clause of the ALTER DATABASE statement. ... To allow multiple connections, the database must be changed to ...
      (microsoft.public.data.ado)
    • Re: ORA-12518, 04030 errors after 9i-10G upgrade.
      ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... This did not solve problems so bounced database and decreased SGA to ... out of process memory errors. ...
      (comp.databases.oracle.server)
    • Re: ORA-12518, 04030 errors after 9i-10G upgrade.
      ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... out of process memory errors. ... that Oracle is having issues with OS resources. ...
      (comp.databases.oracle.server)
    • Re: ORA-12518, 04030 errors after 9i-10G upgrade.
      ... New server has 6GB ram. ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... This did not solve problems so bounced database and decreased SGA to ...
      (comp.databases.oracle.server)
    Loading