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.13
99.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOpe
rationExceptionText&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.1
399&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)

 

 

 

Responder a