I'm trying to remotely create a maintenance plan using the management studio in order to backup databases. I get the following 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
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
The server doesn't have the Management studio client installed so I can't create the maintenance plan locally. If I install just the Management studio will the data currently in the server be effected? Any solution to the remote problem?
Thanks,
Neil
SSIS(SQL Server integration services) need to be installed along with the server, for executing maintenace plans successfully.
For SP1, the current plan is either SSIS or tools installed on the server box would address this issue.
Gops Dwarak
No comments:
Post a Comment