Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-12 : 08:59:25
|
| Neil writes "I'm trying to create a maintenance plan on a remote server using the Management Studio client on my pc in order to schedule a full database backup. 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///////////////////////////////////////////////////////////////Any help will be appreciated!!Thanks,Neil" |
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-01-13 : 05:19:39
|
| Is the remote server enabled to allow other servers connect to it? Via Configuration Tools - Surface Area Configuration. |
 |
|
|
|
|
|
Creating Maintenance Plans remotely