restore master database using sqlservr.exe at command line

When I restore master database by executing sqlservr.exe
at command line I encountered an error message:
Cannot find the file 'C:\Program' (or one of its
components). Make sure the path and filename are correct
and that all required libraries are available.
I have checked sqlservr.exe file it is there.
Thank you for help in advance.
Jeff LeeJeff
It sounds like you might have just specified the location of the executable
incorrectly. Can you actual move to the right directory first, and then run
sqlservr.exe right from there? Or show us the entire command line you are
using.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
<anonymous@.discussions.microsoft.com> wrote in message
news:039901c3d3c7$9c67d930$a101280a@.phx.gbl...
> When I restore master database by executing sqlservr.exe
> at command line I encountered an error message:
> Cannot find the file 'C:\Program' (or one of its
> components). Make sure the path and filename are correct
> and that all required libraries are available.
> I have checked sqlservr.exe file it is there.
> Thank you for help in advance.
> Jeff Lee|||Kalen,
Thank you for your direction. Following is the command I
used in command line
C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\sqlservr.exe -c -m
It appears that sqlservr.exe reacts (quickly shows command
window and disappears serveral seconds later) when just
executing it without parameters -c -m.
>--Original Message--
>Jeff
>It sounds like you might have just specified the location
of the executable
>incorrectly. Can you actual move to the right directory
first, and then run
>sqlservr.exe right from there? Or show us the entire
command line you are
>using.
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:039901c3d3c7$9c67d930$a101280a@.phx.gbl...
>> When I restore master database by executing sqlservr.exe
>> at command line I encountered an error message:
>> Cannot find the file 'C:\Program' (or one of its
>> components). Make sure the path and filename are correct
>> and that all required libraries are available.
>> I have checked sqlservr.exe file it is there.
>> Thank you for help in advance.
>> Jeff Lee
>
>.
>|||If you use that as the command, the parser will choke at the first space and
give you the error about Program not being recognized. You could put the
whole command in quotes, or as I suggested, first navigate to the binn
directory, and run sqlservr.exe from there.
If I put the command below in quotes, with or without the parameters, it
starts the SQL Server in that command window. From another command window,
or from QA, I can connect normally. Note that if you close the command
window where you started SQL Server it will stop the SQL Server.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
<anonymous@.discussions.microsoft.com> wrote in message
news:03ff01c3d3cc$da6e0ba0$a101280a@.phx.gbl...
> Kalen,
> Thank you for your direction. Following is the command I
> used in command line
> C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\sqlservr.exe -c -m
> It appears that sqlservr.exe reacts (quickly shows command
> window and disappears serveral seconds later) when just
> executing it without parameters -c -m.
>
> >--Original Message--
> >Jeff
> >
> >It sounds like you might have just specified the location
> of the executable
> >incorrectly. Can you actual move to the right directory
> first, and then run
> >sqlservr.exe right from there? Or show us the entire
> command line you are
> >using.
> >
> >--
> >HTH
> >--
> >Kalen Delaney
> >SQL Server MVP
> >www.SolidQualityLearning.com
> >
> >
> ><anonymous@.discussions.microsoft.com> wrote in message
> >news:039901c3d3c7$9c67d930$a101280a@.phx.gbl...
> >> When I restore master database by executing sqlservr.exe
> >> at command line I encountered an error message:
> >>
> >> Cannot find the file 'C:\Program' (or one of its
> >> components). Make sure the path and filename are correct
> >> and that all required libraries are available.
> >>
> >> I have checked sqlservr.exe file it is there.
> >>
> >> Thank you for help in advance.
> >>
> >> Jeff Lee
> >
> >
> >.
> >

restore master database in sql server 2005

How do I restore the master database from a backup or how can i rebuild the
master?
I can not find a rebuildm.exe utility for 2005 and when I try to restore the
database from a backup in SQL server management studio.
Could someone give me instructions on how to either restore or rebuild the
database step by step?
THANKS IN ADVANCE...
Mike
Does the question relate top SQL Server 2000 or SQL Server 2005?
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:5A68D926-8660-4935-9AEC-2E7B8FF04AC4@.microsoft.com...
> How do I restore the master database from a backup or how can i rebuild
> the
> master?
> I can not find a rebuildm.exe utility for 2005 and when I try to restore
> the
> database from a backup in SQL server management studio.
> Could someone give me instructions on how to either restore or rebuild the
> database step by step?
> THANKS IN ADVANCE...
>
|||Hi
SQL Server 2005 support here:
http://communities.microsoft.com/new...=sqlserver2005
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike" wrote:

> How do I restore the master database from a backup or how can i rebuild the
> master?
> I can not find a rebuildm.exe utility for 2005 and when I try to restore the
> database from a backup in SQL server management studio.
> Could someone give me instructions on how to either restore or rebuild the
> database step by step?
> THANKS IN ADVANCE...
>

restore master database in sql server 2005

How do I restore the master database from a backup or how can i rebuild the
master?
I can not find a rebuildm.exe utility for 2005 and when I try to restore the
database from a backup in SQL server management studio.
Could someone give me instructions on how to either restore or rebuild the
database step by step?
THANKS IN ADVANCE...Mike
Does the question relate top SQL Server 2000 or SQL Server 2005?
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:5A68D926-8660-4935-9AEC-2E7B8FF04AC4@.microsoft.com...
> How do I restore the master database from a backup or how can i rebuild
> the
> master?
> I can not find a rebuildm.exe utility for 2005 and when I try to restore
> the
> database from a backup in SQL server management studio.
> Could someone give me instructions on how to either restore or rebuild the
> database step by step?
> THANKS IN ADVANCE...
>|||Hi
SQL Server 2005 support here:
http://communities.microsoft.com/ne...p=sqlserver2005
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike" wrote:

> How do I restore the master database from a backup or how can i rebuild th
e
> master?
> I can not find a rebuildm.exe utility for 2005 and when I try to restore t
he
> database from a backup in SQL server management studio.
> Could someone give me instructions on how to either restore or rebuild the
> database step by step?
> THANKS IN ADVANCE...
>

restore master database in sql server 2005

How do I restore the master database from a backup or how can i rebuild the
master?
I can not find a rebuildm.exe utility for 2005 and when I try to restore the
database from a backup in SQL server management studio.
Could someone give me instructions on how to either restore or rebuild the
database step by step?
THANKS IN ADVANCE...Mike
Does the question relate top SQL Server 2000 or SQL Server 2005?
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:5A68D926-8660-4935-9AEC-2E7B8FF04AC4@.microsoft.com...
> How do I restore the master database from a backup or how can i rebuild
> the
> master?
> I can not find a rebuildm.exe utility for 2005 and when I try to restore
> the
> database from a backup in SQL server management studio.
> Could someone give me instructions on how to either restore or rebuild the
> database step by step?
> THANKS IN ADVANCE...
>|||Hi
SQL Server 2005 support here:
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike" wrote:
> How do I restore the master database from a backup or how can i rebuild the
> master?
> I can not find a rebuildm.exe utility for 2005 and when I try to restore the
> database from a backup in SQL server management studio.
> Could someone give me instructions on how to either restore or rebuild the
> database step by step?
> THANKS IN ADVANCE...
>

restore master database backup to a new server, single user mode

Hi,
I am using Win2000+SQL2000.
I have a backup copy of MASTER database, I need to retore it my newly setup
SQL server.
I use the command "sqlservr.exe -c -m" from DOS command prompt to startup
SQL server single user,
I can not connect to this sql servre instance by using SQL query analyzer,
kindly please tell me the steps to restore the master database to a new
server.
Thanks
Michael
Hi,
What is the error you are getting while connecting to query analyzer.
Have a look into steps (15 - 28) in the attached link.
http://www.dbarecovery.com/restoremasterdb.html
You have to restore the Master database and then the user databases.
Otherwise Master database restore will
overwrite the existing database entries.
Thanks
Hari
MCDBA
"Michael" <Ruihuiwen@.hotmail.com> wrote in message
news:Oo6cOqNgEHA.3132@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using Win2000+SQL2000.
> I have a backup copy of MASTER database, I need to retore it my newly
setup
> SQL server.
> I use the command "sqlservr.exe -c -m" from DOS command prompt to startup
> SQL server single user,
> I can not connect to this sql servre instance by using SQL query analyzer,
> kindly please tell me the steps to restore the master database to a new
> server.
> Thanks
> Michael
>
>
>

restore master database backup to a new server, single user mode

Hi,
I am using Win2000+SQL2000.
I have a backup copy of MASTER database, I need to retore it my newly setup
SQL server.
I use the command "sqlservr.exe -c -m" from DOS command prompt to startup
SQL server single user,
I can not connect to this sql servre instance by using SQL query analyzer,
kindly please tell me the steps to restore the master database to a new
server.
Thanks
MichaelHi,
What is the error you are getting while connecting to query analyzer.
Have a look into steps (15 - 28) in the attached link.
http://www.dbarecovery.com/restoremasterdb.html
You have to restore the Master database and then the user databases.
Otherwise Master database restore will
overwrite the existing database entries.
Thanks
Hari
MCDBA
"Michael" <Ruihuiwen@.hotmail.com> wrote in message
news:Oo6cOqNgEHA.3132@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am using Win2000+SQL2000.
> I have a backup copy of MASTER database, I need to retore it my newly
setup
> SQL server.
> I use the command "sqlservr.exe -c -m" from DOS command prompt to startup
> SQL server single user,
> I can not connect to this sql servre instance by using SQL query analyzer,
> kindly please tell me the steps to restore the master database to a new
> server.
> Thanks
> Michael
>
>
>