database problem: exe

Showing posts with label exe. Show all posts

Monday, March 12, 2012

Restoring Master Database...

Hello All,
I am trying to test my master and MSDB restore actvities.
1. When I try to run SQL Server on single user mode(DOS prompt command
sqlservr.exe -m) it is taking forever... If the SQL Server is started in
single user mode will I get the DOS prompt again? It it normal that
launching SQL Server in single user mode is taking time?
2. After launching the server in single user mode, the next step is
launching EM and restore the master database like any other user database
restore? OR any special sequence is required.
3. To restore the MSDB should the SQL Server be running in single user mode?
SQL 2K.
Thank you very much.
Johnson
1. Try using: sqlservr.exe -c -m
It's not normal to take a long time but it depends on your
definition of a long time. The output to the screen should
give you an idea of what is taking how long. You won't get a
second DOS screen.
2. Yes but SQL Server will shut down after you restore the
master database.
You can find the steps in books online under the topic:
Restoring the master Database from a Current Backup
3. No...but you can't restore a database that is being
accessed so make sure the SQL Server Agent isn't running.
Refer to the article in books online:
Restoring the model, msdb, and distribution Databases
-Sue
On Mon, 15 Aug 2005 19:27:50 -0700, "Johnson Smith"
<JJSmith@.hotmail.com> wrote:

>Hello All,
>I am trying to test my master and MSDB restore actvities.
>1. When I try to run SQL Server on single user mode(DOS prompt command
>sqlservr.exe -m) it is taking forever... If the SQL Server is started in
>single user mode will I get the DOS prompt again? It it normal that
>launching SQL Server in single user mode is taking time?
>2. After launching the server in single user mode, the next step is
>launching EM and restore the master database like any other user database
>restore? OR any special sequence is required.
>3. To restore the MSDB should the SQL Server be running in single user mode?
>SQL 2K.
>Thank you very much.
>Johnson
>
|||Hi,
(1)From command prompt switch to the approprite directory and use this
sqlservr.exe -c -m
It is normal it take long time
if would be better firt stop the services and start services again
(2)Yes sql server has to be restarted so that new setting should take
place.
(3)To restore the master database just stop all the serveices and
detach the database and rename the database mdf file name and copy the
backed up msdb database in the location and attach the database agin.
Hope this help u
from
killer
Sue Hoegemeier wrote:[vbcol=seagreen]
> 1. Try using: sqlservr.exe -c -m
> It's not normal to take a long time but it depends on your
> definition of a long time. The output to the screen should
> give you an idea of what is taking how long. You won't get a
> second DOS screen.
> 2. Yes but SQL Server will shut down after you restore the
> master database.
> You can find the steps in books online under the topic:
> Restoring the master Database from a Current Backup
> 3. No...but you can't restore a database that is being
> accessed so make sure the SQL Server Agent isn't running.
> Refer to the article in books online:
> Restoring the model, msdb, and distribution Databases
> -Sue
> On Mon, 15 Aug 2005 19:27:50 -0700, "Johnson Smith"
> <JJSmith@.hotmail.com> wrote:
|||Thank you very much for the response.
I understand that I would not get the second DOS screen. I think I should
have made my question very clear.
After entering sqlservr.exe -c -m in the DOS prompt how exactly I will come
to know that SQL Server agent is started in the single user mode. It did
display some text after executing the above command. How I will come to know
it finished the job of starting SQL Server in single user mode? Will I get
the DOS prompt again in the same DOS shell where I executed the line
sqlservr.exe -c -m?
Thanks,
Johnson
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:nkl2g19i0oreq3k21g44hku5vs0n0rnm43@.4ax.com...
> 1. Try using: sqlservr.exe -c -m
> It's not normal to take a long time but it depends on your
> definition of a long time. The output to the screen should
> give you an idea of what is taking how long. You won't get a
> second DOS screen.
> 2. Yes but SQL Server will shut down after you restore the
> master database.
> You can find the steps in books online under the topic:
> Restoring the master Database from a Current Backup
> 3. No...but you can't restore a database that is being
> accessed so make sure the SQL Server Agent isn't running.
> Refer to the article in books online:
> Restoring the model, msdb, and distribution Databases
> -Sue
> On Mon, 15 Aug 2005 19:27:50 -0700, "Johnson Smith"
> <JJSmith@.hotmail.com> wrote:
>
|||First, it should be SQL Server not SQ Agent that you are
starting up. If you read the output on the screen, it should
display lines something like:
warning *****
SQL Server started in single user mode
starting up database master
and then other lines for starting up your other databases,
and you will see a line when it is ready for client
connections although other databases may start up after
that. And then it just sits so if you aren't used to doing
this, it may seem like it is hung. You just having to get
used to doing it or practice with a server with few, if any
user databases. Then you can tell by looking at what
databases have started up.
-Sue
On Mon, 15 Aug 2005 21:30:09 -0700, "Johnson Smith"
<JJSmith@.hotmail.com> wrote:

>Thank you very much for the response.
>I understand that I would not get the second DOS screen. I think I should
>have made my question very clear.
>After entering sqlservr.exe -c -m in the DOS prompt how exactly I will come
>to know that SQL Server agent is started in the single user mode. It did
>display some text after executing the above command. How I will come to know
>it finished the job of starting SQL Server in single user mode? Will I get
>the DOS prompt again in the same DOS shell where I executed the line
>sqlservr.exe -c -m?
>Thanks,
>Johnson
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:nkl2g19i0oreq3k21g44hku5vs0n0rnm43@.4ax.com.. .
>
|||Oh and look for the last line of Recovery complete.
-Sue
On Mon, 15 Aug 2005 21:30:09 -0700, "Johnson Smith"
<JJSmith@.hotmail.com> wrote:

>Thank you very much for the response.
>I understand that I would not get the second DOS screen. I think I should
>have made my question very clear.
>After entering sqlservr.exe -c -m in the DOS prompt how exactly I will come
>to know that SQL Server agent is started in the single user mode. It did
>display some text after executing the above command. How I will come to know
>it finished the job of starting SQL Server in single user mode? Will I get
>the DOS prompt again in the same DOS shell where I executed the line
>sqlservr.exe -c -m?
>Thanks,
>Johnson
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:nkl2g19i0oreq3k21g44hku5vs0n0rnm43@.4ax.com.. .
>
|||That means If I see the message recovery complete I am ready to connect
through the EM and do my master database restore? SQL Server agent will
never start when I issue the sqlservr.exe -c -m? Even though SQL Server
agent is not running I should not have any problem to connect through the
EM?
Thanks for your quick reply.
Johnson
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:s5s2g11la0rs694mq27u4qtgavhf192ad8@.4ax.com...
> Oh and look for the last line of Recovery complete.
> -Sue
> On Mon, 15 Aug 2005 21:30:09 -0700, "Johnson Smith"
> <JJSmith@.hotmail.com> wrote:
>
|||I am not finding this info in BOL.
As Sue said it has to be by experience. Very strange as how one will guess
like this way!!!
Thanks,
Johnson
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:s5s2g11la0rs694mq27u4qtgavhf192ad8@.4ax.com...
> Oh and look for the last line of Recovery complete.
> -Sue
> On Mon, 15 Aug 2005 21:30:09 -0700, "Johnson Smith"
> <JJSmith@.hotmail.com> wrote:
>
|||Yes.
Just disable the Agent service while you do your restores
and it will make life easier.
-Sue
On Mon, 15 Aug 2005 22:11:26 -0700, "Johnson Smith"
<JJSmith@.hotmail.com> wrote:

>That means If I see the message recovery complete I am ready to connect
>through the EM and do my master database restore? SQL Server agent will
>never start when I issue the sqlservr.exe -c -m? Even though SQL Server
>agent is not running I should not have any problem to connect through the
>EM?
>Thanks for your quick reply.
>Johnson
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:s5s2g11la0rs694mq27u4qtgavhf192ad8@.4ax.com.. .
>
|||Every detail of it isn't in BOL. Scroll down in the DOS
screen and look for recovery complete. What you see on the
screen is just what is written to the SQL log - same thing
you see if you look in the errorlog.
-Sue
On Mon, 15 Aug 2005 23:02:30 -0700, "Johnson Smith"
<JJSmith@.hotmail.com> wrote:

>I am not finding this info in BOL.
>As Sue said it has to be by experience. Very strange as how one will guess
>like this way!!!
>Thanks,
>Johnson
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:s5s2g11la0rs694mq27u4qtgavhf192ad8@.4ax.com.. .
>

Restoring Master Database...

Hello All,
I am trying to test my master and MSDB restore actvities.
1. When I try to run SQL Server on single user mode(DOS prompt command
sqlservr.exe -m) it is taking forever... If the SQL Server is started in
single user mode will I get the DOS prompt again? It it normal that
launching SQL Server in single user mode is taking time?
2. After launching the server in single user mode, the next step is
launching EM and restore the master database like any other user database
restore? OR any special sequence is required.
3. To restore the MSDB should the SQL Server be running in single user mode?
SQL 2K.
Thank you very much.
Johnson1. Try using: sqlservr.exe -c -m
It's not normal to take a long time but it depends on your
definition of a long time. The output to the screen should
give you an idea of what is taking how long. You won't get a
second DOS screen.
2. Yes but SQL Server will shut down after you restore the
master database.
You can find the steps in books online under the topic:
Restoring the master Database from a Current Backup
3. No...but you can't restore a database that is being
accessed so make sure the SQL Server Agent isn't running.
Refer to the article in books online:
Restoring the model, msdb, and distribution Databases
-Sue
On Mon, 15 Aug 2005 19:27:50 -0700, "Johnson Smith"
<JJSmith@.hotmail.com> wrote:

>Hello All,
>I am trying to test my master and MSDB restore actvities.
>1. When I try to run SQL Server on single user mode(DOS prompt command
>sqlservr.exe -m) it is taking forever... If the SQL Server is started in
>single user mode will I get the DOS prompt again? It it normal that
>launching SQL Server in single user mode is taking time?
>2. After launching the server in single user mode, the next step is
>launching EM and restore the master database like any other user database
>restore? OR any special sequence is required.
>3. To restore the MSDB should the SQL Server be running in single user mode
?
>SQL 2K.
>Thank you very much.
>Johnson
>|||Hi,
(1)From command prompt switch to the approprite directory and use this
sqlservr.exe -c -m
It is normal it take long time
if would be better firt stop the services and start services again
(2)Yes sql server has to be restarted so that new setting should take
place.
(3)To restore the master database just stop all the serveices and
detach the database and rename the database mdf file name and copy the
backed up msdb database in the location and attach the database agin.
Hope this help u
from
killer
Sue Hoegemeier wrote:[vbcol=seagreen]
> 1. Try using: sqlservr.exe -c -m
> It's not normal to take a long time but it depends on your
> definition of a long time. The output to the screen should
> give you an idea of what is taking how long. You won't get a
> second DOS screen.
> 2. Yes but SQL Server will shut down after you restore the
> master database.
> You can find the steps in books online under the topic:
> Restoring the master Database from a Current Backup
> 3. No...but you can't restore a database that is being
> accessed so make sure the SQL Server Agent isn't running.
> Refer to the article in books online:
> Restoring the model, msdb, and distribution Databases
> -Sue
> On Mon, 15 Aug 2005 19:27:50 -0700, "Johnson Smith"
> <JJSmith@.hotmail.com> wrote:
>|||Thank you very much for the response.
I understand that I would not get the second DOS screen. I think I should
have made my question very clear.
After entering sqlservr.exe -c -m in the DOS prompt how exactly I will come
to know that SQL Server agent is started in the single user mode. It did
display some text after executing the above command. How I will come to know
it finished the job of starting SQL Server in single user mode? Will I get
the DOS prompt again in the same DOS shell where I executed the line
sqlservr.exe -c -m?
Thanks,
Johnson
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:nkl2g19i0oreq3k21g44hku5vs0n0rnm43@.
4ax.com...
> 1. Try using: sqlservr.exe -c -m
> It's not normal to take a long time but it depends on your
> definition of a long time. The output to the screen should
> give you an idea of what is taking how long. You won't get a
> second DOS screen.
> 2. Yes but SQL Server will shut down after you restore the
> master database.
> You can find the steps in books online under the topic:
> Restoring the master Database from a Current Backup
> 3. No...but you can't restore a database that is being
> accessed so make sure the SQL Server Agent isn't running.
> Refer to the article in books online:
> Restoring the model, msdb, and distribution Databases
> -Sue
> On Mon, 15 Aug 2005 19:27:50 -0700, "Johnson Smith"
> <JJSmith@.hotmail.com> wrote:
>
>|||First, it should be SQL Server not SQ Agent that you are
starting up. If you read the output on the screen, it should
display lines something like:
warning *****
SQL Server started in single user mode
starting up database master
and then other lines for starting up your other databases,
and you will see a line when it is ready for client
connections although other databases may start up after
that. And then it just sits so if you aren't used to doing
this, it may seem like it is hung. You just having to get
used to doing it or practice with a server with few, if any
user databases. Then you can tell by looking at what
databases have started up.
-Sue
On Mon, 15 Aug 2005 21:30:09 -0700, "Johnson Smith"
<JJSmith@.hotmail.com> wrote:

>Thank you very much for the response.
>I understand that I would not get the second DOS screen. I think I should
>have made my question very clear.
>After entering sqlservr.exe -c -m in the DOS prompt how exactly I will come
>to know that SQL Server agent is started in the single user mode. It did
>display some text after executing the above command. How I will come to kno
w
>it finished the job of starting SQL Server in single user mode? Will I get
>the DOS prompt again in the same DOS shell where I executed the line
>sqlservr.exe -c -m?
>Thanks,
>Johnson
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:nkl2g19i0oreq3k21g44hku5vs0n0rnm43@.
4ax.com...
>|||Oh and look for the last line of Recovery complete.
-Sue
On Mon, 15 Aug 2005 21:30:09 -0700, "Johnson Smith"
<JJSmith@.hotmail.com> wrote:

>Thank you very much for the response.
>I understand that I would not get the second DOS screen. I think I should
>have made my question very clear.
>After entering sqlservr.exe -c -m in the DOS prompt how exactly I will come
>to know that SQL Server agent is started in the single user mode. It did
>display some text after executing the above command. How I will come to kno
w
>it finished the job of starting SQL Server in single user mode? Will I get
>the DOS prompt again in the same DOS shell where I executed the line
>sqlservr.exe -c -m?
>Thanks,
>Johnson
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:nkl2g19i0oreq3k21g44hku5vs0n0rnm43@.
4ax.com...
>|||That means If I see the message recovery complete I am ready to connect
through the EM and do my master database restore? SQL Server agent will
never start when I issue the sqlservr.exe -c -m? Even though SQL Server
agent is not running I should not have any problem to connect through the
EM?
Thanks for your quick reply.
Johnson
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:s5s2g11la0rs694mq27u4qtgavhf192ad8@.
4ax.com...
> Oh and look for the last line of Recovery complete.
> -Sue
> On Mon, 15 Aug 2005 21:30:09 -0700, "Johnson Smith"
> <JJSmith@.hotmail.com> wrote:
>
>|||I am not finding this info in BOL.
As Sue said it has to be by experience. Very strange as how one will guess
like this way!!!
Thanks,
Johnson
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:s5s2g11la0rs694mq27u4qtgavhf192ad8@.
4ax.com...
> Oh and look for the last line of Recovery complete.
> -Sue
> On Mon, 15 Aug 2005 21:30:09 -0700, "Johnson Smith"
> <JJSmith@.hotmail.com> wrote:
>
>|||Yes.
Just disable the Agent service while you do your restores
and it will make life easier.
-Sue
On Mon, 15 Aug 2005 22:11:26 -0700, "Johnson Smith"
<JJSmith@.hotmail.com> wrote:

>That means If I see the message recovery complete I am ready to connect
>through the EM and do my master database restore? SQL Server agent will
>never start when I issue the sqlservr.exe -c -m? Even though SQL Server
>agent is not running I should not have any problem to connect through the
>EM?
>Thanks for your quick reply.
>Johnson
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:s5s2g11la0rs694mq27u4qtgavhf192ad8@.
4ax.com...
>|||Every detail of it isn't in BOL. Scroll down in the DOS
screen and look for recovery complete. What you see on the
screen is just what is written to the SQL log - same thing
you see if you look in the errorlog.
-Sue
On Mon, 15 Aug 2005 23:02:30 -0700, "Johnson Smith"
<JJSmith@.hotmail.com> wrote:

>I am not finding this info in BOL.
>As Sue said it has to be by experience. Very strange as how one will guess
>like this way!!!
>Thanks,
>Johnson
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:s5s2g11la0rs694mq27u4qtgavhf192ad8@.
4ax.com...
>

restoring master database - single user mode

I am trying to restore a backup of a master database from one server to a
new server.
I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a command
prompt to start it in single user mode. It finished with "SQL Global
counter collection task is created." It appears to stop at this point -
there is no prompt.
While in single-user mode, I open Query Analyzer and attempt to log in both
with Windows Authentication and with SQL Server authentication, using the sa
login.
In both cases, I get an error "Login failed for user '(login)'. Reason:
Server is in single user mode. Only one administrator can connect at this
time."
Thanks for any suggestions.
-BillThere might be an EM connection that is already open.
"bill" <belgie@.datamti.com> wrote in message
news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> I am trying to restore a backup of a master database from one server to a
> new server.
> I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
command
> prompt to start it in single user mode. It finished with "SQL Global
> counter collection task is created." It appears to stop at this point -
> there is no prompt.
> While in single-user mode, I open Query Analyzer and attempt to log in
both
> with Windows Authentication and with SQL Server authentication, using the
sa
> login.
> In both cases, I get an error "Login failed for user '(login)'. Reason:
> Server is in single user mode. Only one administrator can connect at this
> time."
> Thanks for any suggestions.
> -Bill
>|||Good thought, but that's not it.
Thanks!
"Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> There might be an EM connection that is already open.
> "bill" <belgie@.datamti.com> wrote in message
> news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> > I am trying to restore a backup of a master database from one server to
a
> > new server.
> >
> > I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
> command
> > prompt to start it in single user mode. It finished with "SQL Global
> > counter collection task is created." It appears to stop at this point -
> > there is no prompt.
> >
> > While in single-user mode, I open Query Analyzer and attempt to log in
> both
> > with Windows Authentication and with SQL Server authentication, using
the
> sa
> > login.
> >
> > In both cases, I get an error "Login failed for user '(login)'. Reason:
> > Server is in single user mode. Only one administrator can connect at
this
> > time."
> >
> > Thanks for any suggestions.
> > -Bill
> >
> >
>|||Agent? Other services or users? You need to find who is connected...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> Good thought, but that's not it.
> Thanks!
> "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
> news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> > There might be an EM connection that is already open.
> >
> > "bill" <belgie@.datamti.com> wrote in message
> > news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> > > I am trying to restore a backup of a master database from one server to
> a
> > > new server.
> > >
> > > I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
> > command
> > > prompt to start it in single user mode. It finished with "SQL Global
> > > counter collection task is created." It appears to stop at this point -
> > > there is no prompt.
> > >
> > > While in single-user mode, I open Query Analyzer and attempt to log in
> > both
> > > with Windows Authentication and with SQL Server authentication, using
> the
> > sa
> > > login.
> > >
> > > In both cases, I get an error "Login failed for user '(login)'. Reason:
> > > Server is in single user mode. Only one administrator can connect at
> this
> > > time."
> > >
> > > Thanks for any suggestions.
> > > -Bill
> > >
> > >
> >
> >
>|||How can I do this? I can't connect to SQL Server to see the connections.
Thanks
Bill
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
> Agent? Other services or users? You need to find who is connected...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "bill" <belgie@.datamti.com> wrote in message
news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
> > Good thought, but that's not it.
> >
> > Thanks!
> >
> > "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
> > news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
> > > There might be an EM connection that is already open.
> > >
> > > "bill" <belgie@.datamti.com> wrote in message
> > > news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
> > > > I am trying to restore a backup of a master database from one server
to
> > a
> > > > new server.
> > > >
> > > > I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
> > > command
> > > > prompt to start it in single user mode. It finished with "SQL
Global
> > > > counter collection task is created." It appears to stop at this
point -
> > > > there is no prompt.
> > > >
> > > > While in single-user mode, I open Query Analyzer and attempt to log
in
> > > both
> > > > with Windows Authentication and with SQL Server authentication,
using
> > the
> > > sa
> > > > login.
> > > >
> > > > In both cases, I get an error "Login failed for user '(login)'.
Reason:
> > > > Server is in single user mode. Only one administrator can connect at
> > this
> > > > time."
> > > >
> > > > Thanks for any suggestions.
> > > > -Bill
> > > >
> > > >
> > >
> > >
> >
> >
>|||Start stopping SQL server Agent, and other possible services that might use SQL server. You might
need to get physical access to the machine, or terminal services, so you can work locally on the
machine stopping services and perhaps even disabling network access (which isn't doable over
terminal services, of course).
Another thing you can try is to login using OSQL.EXE instead of Query Analyzer. QA *might* try to
open a connection for Object Browser and that *might* get connected before your query window.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <belgie@.datamti.com> wrote in message news:emBg4NEuEHA.348@.tk2msftngp13.phx.gbl...
> How can I do this? I can't connect to SQL Server to see the connections.
> Thanks
> Bill
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:Oj%23tuBCuEHA.2956@.TK2MSFTNGP12.phx.gbl...
>> Agent? Other services or users? You need to find who is connected...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "bill" <belgie@.datamti.com> wrote in message
> news:ug%23zrT6tEHA.1228@.TK2MSFTNGP10.phx.gbl...
>> > Good thought, but that's not it.
>> >
>> > Thanks!
>> >
>> > "Bhanu" <SQLDBA1999@.yahoo.com> wrote in message
>> > news:epspEa5tEHA.2692@.TK2MSFTNGP10.phx.gbl...
>> > > There might be an EM connection that is already open.
>> > >
>> > > "bill" <belgie@.datamti.com> wrote in message
>> > > news:OvtzHq4tEHA.2124@.TK2MSFTNGP11.phx.gbl...
>> > > > I am trying to restore a backup of a master database from one server
> to
>> > a
>> > > > new server.
>> > > >
>> > > > I stopped the SQL Server services, and ran "sqlservr.exe -c -m" at a
>> > > command
>> > > > prompt to start it in single user mode. It finished with "SQL
> Global
>> > > > counter collection task is created." It appears to stop at this
> point -
>> > > > there is no prompt.
>> > > >
>> > > > While in single-user mode, I open Query Analyzer and attempt to log
> in
>> > > both
>> > > > with Windows Authentication and with SQL Server authentication,
> using
>> > the
>> > > sa
>> > > > login.
>> > > >
>> > > > In both cases, I get an error "Login failed for user '(login)'.
> Reason:
>> > > > Server is in single user mode. Only one administrator can connect at
>> > this
>> > > > time."
>> > > >
>> > > > Thanks for any suggestions.
>> > > > -Bill
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>

Monday, March 12, 2012

Restoring Master Database...

Restoring Master Database...

restoring master database - single user mode

restoring master database - single user mode

restoring master database - single user mode

database problem

Blog Archive

About Me