Sunday, March 11, 2012

Database Maintenance Planner option disabled

I am using SQL Server 2000 and need to run the maintenance plan wizard,
but the "Database Maintenance Planner" option in the Tools menu is
disabled (greyed out) no matter which node I click on. Google searches
have turned up nothing. Help!Is SQL Server Agent enabled and running?
<unimatter@.gmail.com> wrote in message
news:1167501594.458835.85780@.s34g2000cwa.googlegroups.com...
>I am using SQL Server 2000 and need to run the maintenance plan wizard,
> but the "Database Maintenance Planner" option in the Tools menu is
> disabled (greyed out) no matter which node I click on. Google searches
> have turned up nothing. Help!
>|||Hi
"unimatter@.gmail.com" wrote:

> I am using SQL Server 2000 and need to run the maintenance plan wizard,
> but the "Database Maintenance Planner" option in the Tools menu is
> disabled (greyed out) no matter which node I click on. Google searches
> have turned up nothing. Help!
>
I am not sure why it is greyed out, but why not write your own call to
xp_sqlmaint or use sqlmaint.exe from the command prompt?
John|||Hi
Just to add, the "database maintenance plan" option is normally available
when you are on the server node, datebase node etc.
John

No comments:

Post a Comment