Created 'Database Maintenance Plans' to check integrity
of database, to update statistics for query analyzer
queries, to update data pages and index pages.
The Database Maintenance Plans jobs are failing with
error: 4062, cannot open user default database '<ID>'.
Using master instead. The weird thing about it is that
the error refers to an old job/master plan name.
It looks like the database for Database Maintenance Plans
is corrupted - using data from old plans for new plans.
What needs to be done to fix this problem?Using SQL Server 7 and Windows 2000 server.
>--Original Message--
>Created 'Database Maintenance Plans' to check integrity
>of database, to update statistics for query analyzer
>queries, to update data pages and index pages.
>The Database Maintenance Plans jobs are failing with
>error: 4062, cannot open user default database '<ID>'.
>Using master instead. The weird thing about it is that
>the error refers to an old job/master plan name.
>It looks like the database for Database Maintenance
Plans
>is corrupted - using data from old plans for new plans.
>What needs to be done to fix this problem?
>.
>|||The output text file was refering to a previous job. No
other references to previous jobs was seen.
>--Original Message--
>Created 'Database Maintenance Plans' to check integrity
>of database, to update statistics for query analyzer
>queries, to update data pages and index pages.
>The Database Maintenance Plans jobs are failing with
>error: 4062, cannot open user default database '<ID>'.
>Using master instead. The weird thing about it is that
>the error refers to an old job/master plan name.
>It looks like the database for Database Maintenance
Plans
>is corrupted - using data from old plans for new plans.
>What needs to be done to fix this problem?
>.
>|||Solved the issue. The MSSQLSERVER service login default
database had been changed to point to a database other
then 'master'. Apparently this is a prerequisite for
jobs to run. Once the MSSQLSERVER service login was
pointed at the 'master' database jobs ran.
No comments:
Post a Comment