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. 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...
>
|||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
|||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...
>
|||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...
>

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
>>
>>
>>
>

error creating maintenance plan

Hello,
I'm creating a maintenance plan for a SQL SERVER DB in 64 bits. The plan
includes rebuild indexes, check integrity, update statistics, etc.
I'm using the wizard to create to plan, but at the when I press the finish
button at the end of the wizard there is an error message and I'm unable to
create the plan.
The error message is include at the end of this email.
Does anybody know what could be causing the error?
In advance I appreciate your help and comments.
Edmundo J. Davila
ERROR
TITLE: Maintenance Plan Wizard Progress
Create maintenance plan failed.
ADDITIONAL INFORMATION:
Create failed for JobStep 'Subplan'.
(Microsoft.SqlServer.MaintenancePlanTasks)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Create+JobStep&LinkId=20476[/url]
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The specified '@.subsystem' is invalid (valid values are returned by
sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476[ /url]
BUTTONS:
OK
This question has already been answered.
Ekrem nsoy
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:4F578C0F-8F8A-4371-88B1-C6FDA8C0D4AD@.microsoft.com...
> Hello,
> I'm creating a maintenance plan for a SQL SERVER DB in 64 bits. The plan
> includes rebuild indexes, check integrity, update statistics, etc.
> I'm using the wizard to create to plan, but at the when I press the finish
> button at the end of the wizard there is an error message and I'm unable
> to create the plan.
> The error message is include at the end of this email.
> Does anybody know what could be causing the error?
> In advance I appreciate your help and comments.
> Edmundo J. Davila
> ERROR
>
> TITLE: Maintenance Plan Wizard Progress
> --
> Create maintenance plan failed.
> --
> ADDITIONAL INFORMATION:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Create+JobStep&LinkId=20476[/url]
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476[ /url]
> --
> BUTTONS:
> OK
> --
>

error creating maintenance plan

Hello,
I'm creating a maintenance plan for a SQL SERVER DB in 64 bits. The plan
includes rebuild indexes, check integrity, update statistics, etc.
I'm using the wizard to create to plan, but at the when I press the finish
button at the end of the wizard there is an error message and I'm unable to
create the plan.
The error message is include at the end of this email.
Does anybody know what could be causing the error?
In advance I appreciate your help and comments.
Edmundo J. Davila
ERROR
---
TITLE: Maintenance Plan Wizard Progress
--
Create maintenance plan failed.
--
ADDITIONAL INFORMATION:
Create failed for JobStep 'Subplan'.
(Microsoft.SqlServer.MaintenancePlanTasks)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
The specified '@.subsystem' is invalid (valid values are returned by
sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
--
BUTTONS:
OK
--This question has already been answered.
--
Ekrem Önsoy
"Edmundo J. Davila" <edavila@.monisa.com> wrote in message
news:4F578C0F-8F8A-4371-88B1-C6FDA8C0D4AD@.microsoft.com...
> Hello,
> I'm creating a maintenance plan for a SQL SERVER DB in 64 bits. The plan
> includes rebuild indexes, check integrity, update statistics, etc.
> I'm using the wizard to create to plan, but at the when I press the finish
> button at the end of the wizard there is an error message and I'm unable
> to create the plan.
> The error message is include at the end of this email.
> Does anybody know what could be causing the error?
> In advance I appreciate your help and comments.
> Edmundo J. Davila
> ERROR
> ---
>
> TITLE: Maintenance Plan Wizard Progress
> --
> Create maintenance plan failed.
> --
> ADDITIONAL INFORMATION:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
> --
> BUTTONS:
> OK
> --
>