Prev: Report Header Parameter Max(Value) from Table...
Next: Determine a server specific ID
From: . on 13 Jul 2010 13:08
Thanks Erland. In looking at the SQL logs there doesn't appear to be any
errors as it mentions for each db as:

"DBCC CHECKDB (UserDB1, repair_fast) executed by Server1\LocalUser found 0
errors and repaired 0 errors. Elapsed time: 0 hours 0 minute 0 seconds."

....for each db, so I'm not quite sure which direction to look for next?




"Erland Sommarskog" <esquel(a)sommarskog.se> wrote in message
news:Xns9DB3E2F33D48DYazorman(a)127.0.0.1...
>. (nothing(a)nothing.com) writes:
>> I tried to change all the dbs to 'Full' (Recover Model) except for
>> 'tempdb' (which prompted it can't be set) which then in looking at the
>> SQL Agent job it shows it failed again. Thought the Recovery model
>> setting would've fixed it but would anyone know how to have the
>> 'Integrity Checks Job...' and 'Transaction Log Backup Job...' to
>> succeed?
>
> The more interesting question is why they fail.
>
> Find the errors with a maintenance plan on SQL 2000 is not always that
> easy, but I believe they are in
> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
> Note: if you install SQL Server differently, so may the exact location
> of the log directory.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000:
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>


From: Erland Sommarskog on 13 Jul 2010 18:19
.. (nothing(a)nothing.com) writes:
> Thanks Erland. In looking at the SQL logs there doesn't appear to be any
> errors as it mentions for each db as:
>
> "DBCC CHECKDB (UserDB1, repair_fast) executed by Server1\LocalUser found 0
> errors and repaired 0 errors. Elapsed time: 0 hours 0 minute 0 seconds."
>
> ...for each db, so I'm not quite sure which direction to look for next?

The job history in SQL Server Agent? Make sure that you check the box
"Show job-step history". I seem to recall that it is the upper-right
corner. But as I recall jobs for maintnenance plans does not produce
anything interesting in Agent. (I've never liked mainteneance plans myself.)

--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

First  |  Prev  | 
Pages: 1 2
Prev: Report Header Parameter Max(Value) from Table...
Next: Determine a server specific ID