|
Home > Archive > MS SQL Server > October 2006 > Restore Error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Bishoy George 2006-10-24, 6:37 pm |
| I have a database in SQL 2000.
When I try to restore the database by enterprise manager I encounter this
error:
Microsoft SQL-DMO(ODBC SQLState: 42000)
Exclusive access could not be obtained because the database is in use,
RESTORE DATABASE is terminating abnormally.
Any help please?
Thanks.
| |
|
| Check for connections on database you're restoring. If there are any, see if
you should disconnect them (kill process) or something similar.
MC
"Bishoy George" <bishoy@bishoy.com> wrote in message
news:%23SLEWkI8GHA.3340@TK2MSFTNGP04.phx.gbl...
> I have a database in SQL 2000.
> When I try to restore the database by enterprise manager I encounter this
> error:
>
> Microsoft SQL-DMO(ODBC SQLState: 42000)
> Exclusive access could not be obtained because the database is in use,
> RESTORE DATABASE is terminating abnormally.
>
> Any help please?
>
> Thanks.
>
>
| |
| Hari Prasad 2006-10-24, 6:37 pm |
| Hi,
Database should not be accessd while Restoring....Execute the below command
to restore a database from Query Analyzer.
ALTER DATABASE <dbname> SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
RESTORE DATABASE Command
GO
ALTER DATABASE <dbname> SET MULTI_USER
Thanks
Hari
"Bishoy George" <bishoy@bishoy.com> wrote in message
news:%23SLEWkI8GHA.3340@TK2MSFTNGP04.phx.gbl...
>I have a database in SQL 2000.
> When I try to restore the database by enterprise manager I encounter this
> error:
>
> Microsoft SQL-DMO(ODBC SQLState: 42000)
> Exclusive access could not be obtained because the database is in use,
> RESTORE DATABASE is terminating abnormally.
>
> Any help please?
>
> Thanks.
>
|
|
|
|
|