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)