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?
> >>.
> >>
>

Maintaining Remote SQL Database

Hi,
I have a sql2k server hosted by my ISP. I need to get the database from
my local development server installed on the sql2k server maintained by
my ISP.
My ISP has told me that there is no enterprise manager access to the
server, any changes to the database need to be done through script or
some other means.
Can anyone provide some guidance on the best practices/methods for doing
this, the thought of manually creating all the tables/relationships/sp's
etc.. on the other machine sounds quite a complex process.
Thanks in advance,
Kieran
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!For the initial database create they will probably allow you to backup your
database and they will restore it. alternitavly use sp_detach_db and they
can attach.
For updates to procs etc you can issue CREATE / DROP / ALTER statements
through Query Analyser or send the .SQL scripts to the ISP
--
HTH
Ryan Waight, MCDBA, MCSE
"Kieran" <anonymous@.devdex.com> wrote in message
news:eePAoX%23kDHA.1948@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a sql2k server hosted by my ISP. I need to get the database from
> my local development server installed on the sql2k server maintained by
> my ISP.
> My ISP has told me that there is no enterprise manager access to the
> server, any changes to the database need to be done through script or
> some other means.
> Can anyone provide some guidance on the best practices/methods for doing
> this, the thought of manually creating all the tables/relationships/sp's
> etc.. on the other machine sounds quite a complex process.
> Thanks in advance,
> Kieran
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Kieran <anonymous@.devdex.com> wrote in message news:<eePAoX#kDHA.1948@.TK2MSFTNGP12.phx.gbl>...
> My ISP has told me that there is no enterprise manager access to the
> server, any changes to the database need to be done through script or
> some other means.
> Can anyone provide some guidance on the best practices/methods for doing
> this, the thought of manually creating all the tables/relationships/sp's
> etc.. on the other machine sounds quite a complex process.
Hi
A web-based administration tool like myLittleAdmin can save you a lot
of time and work. More info, demo and free trial on
http://www.mylittletools.net/mla_sql
Best regards
el.c.