A friend is trying to use the Database Maintenance Plans to build maintenance
jobs for her databases. She is using SQL 2005 Ent Ed. Her account is in the
system administrators role. She can back up the databases by writing the SQL
scripts manually. She can also use the object browser to walk through to the
appropriate database base and right-click to back up the database
... but - when she opens the maintenance wizard, there are not any user
defined databases listed there, only the system databases. I am not local
and I have not actually seen her configuration. Has anyone seen anything
like this?
Thanks.
Ann
I just found out that when the databases were imported, they were set to be
SQL 7.0 compatible. The info in BOL updated July 2006 states that
maintenance plans only work with compat level of 80 or higher.
"alw" wrote:
> A friend is trying to use the Database Maintenance Plans to build maintenance
> jobs for her databases. She is using SQL 2005 Ent Ed. Her account is in the
> system administrators role. She can back up the databases by writing the SQL
> scripts manually. She can also use the object browser to walk through to the
> appropriate database base and right-click to back up the database
> ... but - when she opens the maintenance wizard, there are not any user
> defined databases listed there, only the system databases. I am not local
> and I have not actually seen her configuration. Has anyone seen anything
> like this?
> Thanks.
> Ann
No comments:
Post a Comment