| Author |
Need help to restore master database
|
|
| circulent 2006-10-24, 6:28 pm |
| We backed up our SQL 2005 DB (master.bak, msdb.bak, etc.) and now we have
problems restoring. First we logged on as a local admin, we tried to change
to change to single-user mode by stopping the MSSQLSERVER service (logged as
the local system account), then we typed 'sqlservr.exe -m' at the cmd prompt.
The error we get is this:
ERROR 18461: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason:
Server is in single user mode. Only one administrator can connect at this
time.
Then it repeats itself and generates this message:
ERROR 18461: Login failed for user 'DOMAIN\ADMINISTRATO
R'. Reason: Server is
in single user mode. Only one administrator can connect at this time.
How can we get around this? Thanks
| |
| Tibor Karaszi 2006-10-24, 6:28 pm |
| Somebody else has already logged in. It can be Agent, some user external to the machine or even the
tool you are using connecting using several connections. Hunt it down and make sure you are the only
one.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"circulent" < circulent@discussion
s.microsoft.com> wrote in message
news:1BAEF545-9099-4F31-80AA- FAAD03E39C59@microso
ft.com...
> We backed up our SQL 2005 DB (master.bak, msdb.bak, etc.) and now we have
> problems restoring. First we logged on as a local admin, we tried to change
> to change to single-user mode by stopping the MSSQLSERVER service (logged as
> the local system account), then we typed 'sqlservr.exe -m' at the cmd prompt.
> The error we get is this:
>
> ERROR 18461: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason:
> Server is in single user mode. Only one administrator can connect at this
> time.
>
> Then it repeats itself and generates this message:
>
> ERROR 18461: Login failed for user 'DOMAIN\ADMINISTRATO
R'. Reason: Server is
> in single user mode. Only one administrator can connect at this time.
>
> How can we get around this? Thanks
>
>
>
| |
| circulent 2006-10-24, 6:28 pm |
| any suggestions on how we can hunt it down?
"Tibor Karaszi" wrote:
> Somebody else has already logged in. It can be Agent, some user external to the machine or even the
> tool you are using connecting using several connections. Hunt it down and make sure you are the only
> one.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "circulent" < circulent@discussion
s.microsoft.com> wrote in message
> news:1BAEF545-9099-4F31-80AA- FAAD03E39C59@microso
ft.com...
>
>
| |
| circulent 2006-10-24, 6:28 pm |
| OK I think I got the single-user mode thing take care of. Now I need to get
to Query Analyzer to run 'RESTORE DATABASE master FROM DISK='E:\master.bak' "
but if I try to do it through SQL Svr Mgmt Studio it craps out again with the
same errors above as if I am trying to make another connection. Thoughts?
"Tibor Karaszi" wrote:
> Somebody else has already logged in. It can be Agent, some user external to the machine or even the
> tool you are using connecting using several connections. Hunt it down and make sure you are the only
> one.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "circulent" < circulent@discussion
s.microsoft.com> wrote in message
> news:1BAEF545-9099-4F31-80AA- FAAD03E39C59@microso
ft.com...
>
>
| |
| Tibor Karaszi 2006-10-24, 6:28 pm |
| Perhaps Management Studio opens several connections? Is it configured to open both a query window
and Object Explorer at startup? Use SQLCMD.EXE if the other tools fails.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"circulent" < circulent@discussion
s.microsoft.com> wrote in message
news:31870F5D-F113-41AE-BEEC- 9846133C59F0@microso
ft.com...[color=darkred]
> OK I think I got the single-user mode thing take care of. Now I need to get
> to Query Analyzer to run 'RESTORE DATABASE master FROM DISK='E:\master.bak' "
> but if I try to do it through SQL Svr Mgmt Studio it craps out again with the
> same errors above as if I am trying to make another connection. Thoughts?
>
> "Tibor Karaszi" wrote:
>
| |
| circulent 2006-10-24, 6:29 pm |
| ends up there was a stray service that was logged in under the sme
credentials. once we stopped it we were able to start the sql service under
single-user mode. thanks
"Tibor Karaszi" wrote:
> Perhaps Management Studio opens several connections? Is it configured to open both a query window
> and Object Explorer at startup? Use SQLCMD.EXE if the other tools fails.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "circulent" < circulent@discussion
s.microsoft.com> wrote in message
> news:31870F5D-F113-41AE-BEEC- 9846133C59F0@microso
ft.com...
>
>
|
|
|
|