Maintenance - Integrity Check failure

I've got a database in SQL Server 7/Windows 2000 that is
maintained through 'Database Maintenance Plans'.
Integrity of the database is checked once a week
using 'Integrity Check'. The weekly 'Integrity Check' is
failing. The error message given is 'The job has failed
in step one, please review step 1' and nothing is put
into the application event log. The transaction sql
command for checking the integrity check of a database is
DBCC Checkdb('database'). The command line integrity
check works fine and returns no errors.
Failures are also occuring for 'Update Statistics used by
query optimizer' and 'Reorganize data and index pages' in
Maintenance.
What is causing these maintenance plans to fail?Found log for job:
'Error: 4062, Cannot open user default database '<ID>'.
Using master db instead.'
Will check Microsoft Error list.
>--Original Message--
>I've got a database in SQL Server 7/Windows 2000 that is
>maintained through 'Database Maintenance Plans'.
>Integrity of the database is checked once a week
>using 'Integrity Check'. The weekly 'Integrity Check'
is
>failing. The error message given is 'The job has failed
>in step one, please review step 1' and nothing is put
>into the application event log. The transaction sql
>command for checking the integrity check of a database
is
>DBCC Checkdb('database'). The command line integrity
>check works fine and returns no errors.
>Failures are also occuring for 'Update Statistics used
by
>query optimizer' and 'Reorganize data and index pages'
in
>Maintenance.
>What is causing these maintenance plans to fail?
>.
>|||Hi Jim,
The only thing I can think of is that its found a minor
error and attempted to fix it. Unfortunaly it hasn't
worked as there are still users attached to the db (it
needs to be in single user mode to do it), try a dbcc on
your DB.
J
>--Original Message--
>I've got a database in SQL Server 7/Windows 2000 that is
>maintained through 'Database Maintenance Plans'.
>Integrity of the database is checked once a week
>using 'Integrity Check'. The weekly 'Integrity Check' is
>failing. The error message given is 'The job has failed
>in step one, please review step 1' and nothing is put
>into the application event log. The transaction sql
>command for checking the integrity check of a database is
>DBCC Checkdb('database'). The command line integrity
>check works fine and returns no errors.
>Failures are also occuring for 'Update Statistics used by
>query optimizer' and 'Reorganize data and index pages' in
>Maintenance.
>What is causing these maintenance plans to fail?
>.
>|||If you get this when SQL Agent logs in to run a job then
most likely the default database for the SQL Agent service
account is assigned to a database that no longer exists on
the server. You may want to check the default database for
that account. You'd probably want it set to master.
-Sue
On Wed, 7 Apr 2004 14:24:33 -0700, "Jim"
<anonymous@.discussions.microsoft.com> wrote:
>Found log for job:
>'Error: 4062, Cannot open user default database '<ID>'.
>Using master db instead.'
>Will check Microsoft Error list.
>
>>--Original Message--
>>I've got a database in SQL Server 7/Windows 2000 that is
>>maintained through 'Database Maintenance Plans'.
>>Integrity of the database is checked once a week
>>using 'Integrity Check'. The weekly 'Integrity Check'
>is
>>failing. The error message given is 'The job has failed
>>in step one, please review step 1' and nothing is put
>>into the application event log. The transaction sql
>>command for checking the integrity check of a database
>is
>>DBCC Checkdb('database'). The command line integrity
>>check works fine and returns no errors.
>>Failures are also occuring for 'Update Statistics used
>by
>>query optimizer' and 'Reorganize data and index pages'
>in
>>Maintenance.
>>What is causing these maintenance plans to fail?
>>.|||You should also not automatically repair errors. You shoudl always do
root-cause analysis as these errors are usually an indication that you have
a hardware problem.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:73ma70t1m49tgqnqmk0ccuiopd3qd4n4rj@.4ax.com...
> If you get this when SQL Agent logs in to run a job then
> most likely the default database for the SQL Agent service
> account is assigned to a database that no longer exists on
> the server. You may want to check the default database for
> that account. You'd probably want it set to master.
> -Sue
> On Wed, 7 Apr 2004 14:24:33 -0700, "Jim"
> <anonymous@.discussions.microsoft.com> wrote:
> >Found log for job:
> >
> >'Error: 4062, Cannot open user default database '<ID>'.
> >Using master db instead.'
> >
> >Will check Microsoft Error list.
> >
> >
> >>--Original Message--
> >>I've got a database in SQL Server 7/Windows 2000 that is
> >>maintained through 'Database Maintenance Plans'.
> >>
> >>Integrity of the database is checked once a week
> >>using 'Integrity Check'. The weekly 'Integrity Check'
> >is
> >>failing. The error message given is 'The job has failed
> >>in step one, please review step 1' and nothing is put
> >>into the application event log. The transaction sql
> >>command for checking the integrity check of a database
> >is
> >>DBCC Checkdb('database'). The command line integrity
> >>check works fine and returns no errors.
> >>
> >>Failures are also occuring for 'Update Statistics used
> >by
> >>query optimizer' and 'Reorganize data and index pages'
> >in
> >>Maintenance.
> >>
> >>What is causing these maintenance plans to fail?
> >>.
> >>
>