August 14, 2008 at 9:20 am
I am connecting sql server 2000 sp2 via management studio client tool, I am trying to create a maintanence plan,
but when I try to right click on maintainence plan it doesnt show me the option "create new maintanace plan" it just shows 'view history' and 'refresh' options. Even when I right click database and select task I dont see maintenence plan ooption their. Your post would be valuable.
abhisek
August 14, 2008 at 9:40 am
Are you sure you have the necessary permissions to create a maintenance plan?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 14, 2008 at 10:13 am
You can't create a SQL 2000 maintenance plan in SSMS. You're stuck with using the maintnenance plan stored procedures in msdb of the SQL 2000 instance to create the plan manually or, better yet, find a copy of Enterprise Manager so you can use the wizard.
Greg
August 14, 2008 at 10:15 am
I do have sysadmin previlege and dbo owner role.
August 14, 2008 at 10:19 am
what is the name of the stored procedure and how do i create maintence plan via that stored procedure, can u explain me briefly. since i dont have enterprise manager client tool.
abhisek
August 18, 2008 at 10:57 am
There's a good example of a maintenance plan created without the wizard posted in this thread: http://www.sqlservercentral.com/Forums/Topic488787-8-1.aspx. If it looks complicated, it's because it is.
I believe you can do anything a maintenance plan can do (DBCC CHECKDB, Update stats, Backups) by creating a job and job steps. Maybe you should consider doing that.
Greg
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply