rebuild master

hi,
is there a way to rebuild the master database in sql server 2005 without
installing SQL Server again. I try from the command line, but it sends me to
add/remove program, and from here there are is no option to do that.
in advance i'll appreciatte all your help.
Edmundo J. DavilaYou find instructions for how to rebuild in Books Online:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
More specifically:
start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine
REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
Above it from the BOL topic...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
> hi,
> is there a way to rebuild the master database in sql server 2005 without installing SQL Server
> again. I try from the command line, but it sends me to add/remove program, and from here there are
> is no option to do that.
> in advance i'll appreciatte all your help.
> Edmundo J. Davila|||Tibor,
That instruction send me to the add/remove programs, and as i said, there is
not option to rebuild master database from there.
Edmundo J. Davila
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió
en el mensaje de noticias
news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
> You find instructions for how to rebuild in Books Online:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
> More specifically:
> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName>
> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
> Above it from the BOL topic...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without
>> installing SQL Server again. I try from the command line, but it sends me
>> to add/remove program, and from here there are is no option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>|||Are you running SQL Server Express? If so, why not just detach your user
databases, uninstall / reinstall, then re-attach your user databases?
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
> hi,
> is there a way to rebuild the master database in sql server 2005 without
> installing SQL Server again. I try from the command line, but it sends me
> to add/remove program, and from here there are is no option to do that.
> in advance i'll appreciatte all your help.
> Edmundo J. Davila|||Strange. I just tried the URL and it took me to the below topic:
How to: Install SQL Server 2005 from the Command Prompt
In there (towards the end) there's a sample on how to rebuild. Or are you saying that the START
command that I pasted (after adjustment) took you to add/Remove programs?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
> Tibor,
> That instruction send me to the add/remove programs, and as i said, there is not option to rebuild
> master database from there.
> Edmundo J. Davila
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió en el mensaje de
> noticias news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine
>> REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without installing SQL Server
>> again. I try from the command line, but it sends me to add/remove program, and from here there
>> are is no option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>|||How about this link?
How to: Install SQL Server 2005 from the Command Prompt:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
--
Ekrem Önsoy
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
> Tibor,
> That instruction send me to the add/remove programs, and as i said, there
> is not option to rebuild master database from there.
> Edmundo J. Davila
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> escribió en el mensaje de noticias
> news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName>
>> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without
>> installing SQL Server again. I try from the command line, but it sends
>> me to add/remove program, and from here there are is no option to do
>> that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>|||That is the same article as I posted, but I posted a local BOL URL...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:6F10DBDF-C18B-4C7F-9CC7-AC63878907D1@.microsoft.com...
> How about this link?
> How to: Install SQL Server 2005 from the Command Prompt:
> http://msdn2.microsoft.com/en-us/library/ms144259.aspx
> --
> Ekrem Önsoy
>
> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
> news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
>> Tibor,
>> That instruction send me to the add/remove programs, and as i said, there is not option to
>> rebuild master database from there.
>> Edmundo J. Davila
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió en el mensaje de
>> noticias news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine
>> REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without installing SQL Server
>> again. I try from the command line, but it sends me to add/remove program, and from here there
>> are is no option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>>
>|||Yes Tibor I know, I just thought this link could direct him to the mentioned
web site as the link you gave didn't work for him as far as I see.
--
Ekrem Önsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23fm8pD3JIHA.2064@.TK2MSFTNGP06.phx.gbl...
> That is the same article as I posted, but I posted a local BOL URL...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:6F10DBDF-C18B-4C7F-9CC7-AC63878907D1@.microsoft.com...
>> How about this link?
>> How to: Install SQL Server 2005 from the Command Prompt:
>> http://msdn2.microsoft.com/en-us/library/ms144259.aspx
>> --
>> Ekrem Önsoy
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
>> Tibor,
>> That instruction send me to the add/remove programs, and as i said,
>> there is not option to rebuild master database from there.
>> Edmundo J. Davila
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
>> escribió en el mensaje de noticias
>> news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName>
>> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005
>> without installing SQL Server again. I try from the command line, but
>> it sends me to add/remove program, and from here there are is no
>> option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>>
>|||OK, got it. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:5667FAAD-2499-41BF-AF08-6370F9453042@.microsoft.com...
> Yes Tibor I know, I just thought this link could direct him to the mentioned web site as the link
> you gave didn't work for him as far as I see.
> --
> Ekrem Önsoy
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23fm8pD3JIHA.2064@.TK2MSFTNGP06.phx.gbl...
>> That is the same article as I posted, but I posted a local BOL URL...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
>> news:6F10DBDF-C18B-4C7F-9CC7-AC63878907D1@.microsoft.com...
>> How about this link?
>> How to: Install SQL Server 2005 from the Command Prompt:
>> http://msdn2.microsoft.com/en-us/library/ms144259.aspx
>> --
>> Ekrem Önsoy
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
>> Tibor,
>> That instruction send me to the add/remove programs, and as i said, there is not option to
>> rebuild master database from there.
>> Edmundo J. Davila
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió en el mensaje de
>> noticias news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine
>> REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>> hi,
>> is there a way to rebuild the master database in sql server 2005 without installing SQL
>> Server again. I try from the command line, but it sends me to add/remove program, and from
>> here there are is no option to do that.
>> in advance i'll appreciatte all your help.
>> Edmundo J. Davila
>>
>>
>|||Unfortunatelly I had to remove and reinstall the instance from add/remove
programs from the control panel. It was impossible to do it with your
recommendations.
I appreciatte your help.
Regards,
Edmundo J. Davila
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió
en el mensaje de noticias news:eOZc3a3JIHA.2480@.TK2MSFTNGP05.phx.gbl...
> OK, got it. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:5667FAAD-2499-41BF-AF08-6370F9453042@.microsoft.com...
>> Yes Tibor I know, I just thought this link could direct him to the
>> mentioned web site as the link you gave didn't work for him as far as I
>> see.
>> --
>> Ekrem Önsoy
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:%23fm8pD3JIHA.2064@.TK2MSFTNGP06.phx.gbl...
>> That is the same article as I posted, but I posted a local BOL URL...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
>> news:6F10DBDF-C18B-4C7F-9CC7-AC63878907D1@.microsoft.com...
>> How about this link?
>> How to: Install SQL Server 2005 from the Command Prompt:
>> http://msdn2.microsoft.com/en-us/library/ms144259.aspx
>> --
>> Ekrem Önsoy
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:07571BB5-F191-4A27-BE90-D7C5CFFAD132@.microsoft.com...
>> Tibor,
>> That instruction send me to the add/remove programs, and as i said,
>> there is not option to rebuild master database from there.
>> Edmundo J. Davila
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
>> escribió en el mensaje de noticias
>> news:3DE016B4-97A4-4B50-B7F9-71DF21C8AAE5@.microsoft.com...
>> You find instructions for how to rebuild in Books Online:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
>> More specifically:
>> start /wait <CD or DVD Drive>\setup.exe /qn
>> INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1
>> SAPWD=<NewStrongPassword>
>> Above it from the BOL topic...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Edmundo J. Davila" <edavila@.monisa.com> wrote in message
>> news:10627F4D-46CA-4AD0-98E6-7958CA88A26D@.microsoft.com...
>>> hi,
>>> is there a way to rebuild the master database in sql server 2005
>>> without installing SQL Server again. I try from the command line,
>>> but it sends me to add/remove program, and from here there are is no
>>> option to do that.
>>>
>>> in advance i'll appreciatte all your help.
>>>
>>> Edmundo J. Davila
>>
>>
>>
>