Revisa esto por favor Error message when you create a new maintenance plan in SQL Server 2005: "Create maintenance plan failed" http://support.microsoft.com/kb/909036 -------------------------------- Atte. Ing. Jose Mariano Alvarez SQL Total Consulting
On Sun, Sep 21, 2008 at 18:56, Maxi Accotto <[EMAIL PROTECTED]> wrote: > Service pack?? > > 2008/9/21 Jesús dos Santos <[EMAIL PROTECTED]>: > > Lista, estoy tratando de hacer un plan de mantenimiento para respaldar > las > > bases de datos sql2005, y al final del asistente me tira el siguiente > error: > > > > Muchas gracias desde ya. > > > > > > > > Maintenance Plan Wizard Progress > > > > > > > > - Creating maintenance plan "Respaldos" (Error) > > > > Messages > > > > * 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 > > > > > > > > > > > > - Adding tasks to the maintenance plan (Stopped) > > > > > > > > - Adding scheduling options (Stopped) > > > > > > > > - Adding reporting options (Stopped) > > > > > > > > - Saving maintenance plan "Respaldos" (Stopped) > > > > > > > > > > > > > > > > __________ Información de ESET NOD32 Antivirus, versión de la base de > firmas > > de virus 3458 (20080921) __________ > > > > ESET NOD32 Antivirus ha comprobado este mensaje. > > http://www.eset.com > > > > > > -- > ----------------------------------------------------------- > Microsoft MVP en SQL Server > Consultor en SQLTotalConsulting > Excelencia en servicios y consultoria SQLServer > www.sqltotalconsulting.com > ----------------------------------------------------------- > >
