February 9, 2011 at 8:43 am
This is an error message I get when I try to modify my maintance plan:
This maintenance plan has been modified using a tool other than the maintenance plan designer. You must use SQL Server Integration Services to modify this maintenance plan from now on. (ObjectExplorer)
February 9, 2011 at 9:06 am
Is BIDS installed on that server.??
SSIS is a must for maintenance plans.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
February 10, 2011 at 8:27 am
Do you also have SQL 2008 on the same server ?
Another thread suggests that might be a problem with maint plans .... just a guess
http://www.sqlservercentral.com/Forums/Topic1052208-357-1.aspx
February 10, 2011 at 2:33 pm
SKYBVI (2/9/2011)
Is BIDS installed on that server.??SSIS is a must for maintenance plans.
Regards,
Sushant
No - it is not a requirement. It is a requirement for specific versions (e.g. SQL Server 2005 RTM), but is not required for SP1 or greater. It is also required on SQL Server 2008 RTM, but not on later service packs.
Once again, this issue is caused because of a conflict between the client version and the server version. If the server version is on SP3 - and the client tools are RTM you cannot create or edit maintenance plans on that server. Also, if your client tools are SP3 and the server version is less than SP2 - you cannot create or edit maintenance plans.
Actually, you might be able to - but then you are going to have all kinds of problems managing them later on.
This is an error message I get when I try to modify my maintance plan:
This maintenance plan has been modified using a tool other than the maintenance plan designer. You must use SQL Server Integration Services to modify this maintenance plan from now on. (ObjectExplorer)
The above error means that someone imported the plan into BIDS, edited the plan in BIDS and then exported (Save As) from BIDS back to the server. This can be done, as long as you DO NOT ADD/REMOVE any existing items and only update the connection information or set the basic information on the tasks (i.e. Databases to be backed up, path information, etc...).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 11, 2011 at 8:15 am
Have you tried to create a new backup job with the databases and backup folders with a cleanup task?
I have the same problem on some of my servers, but I find that I can create a new job and disable the other management task jobs that are generated.
John.
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply