SQL SERVER 2005数据库备份排程出错
我在做一个数据库备份排程时,老是出错!
错误信息是:
Create maintenance plan failed.
Additional information:
Create failed for JobStep 'Subplan '.(Micorsoft SqlServer.MaintenancePlanTasks)
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)
我安装的版本是:Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
[解决办法]
是你的sql语句中的变量@@subsystem引用无效，最好把你的整个sql贴出来
