Re: DB Integrity Check

You still have a database corruption issue that you need to address. You
should run DBCC CHECKDB at the next opportunity. Note: this will heavily
impact your server, so don't do it when it will impact your users.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"CyberFox" <CyberFox@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DC79220C-EAF8-4DB7-8D67-55F3E8AB1879@xxxxxxxxxxxxxxxx
Hi there,
I already looked at this location, but it gave me more or less the same
info
as the event viewer.
However, I did de-select the repair checkbox, and it's now running.
Thank you very much


"Geoff N. Hiten" wrote:

Right click on the Maintenance Plan in Enterprise Manager and look at the
plan history. It will tell you a more specific error message. The
typical
failure in this circumstance is when you have the "Attempt to Repair
Minor
Errors" checkbox checked. The Maintanence Plan must put the database
into
Single-User mode to fix the problem. I strongly recommend never checking
this box as it can hide minor errors until they become major ones.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


"CyberFox" <CyberFox@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:91890A63-1AF6-43F5-A4F9-439E31528A91@xxxxxxxxxxxxxxxx
Hi there,
I have a job that runs a db integrity check every week, but for the
past
two
weeks this job is failing. I cannot see why, cos the logs don't really
specifiy anything.

The event viewer gives the following message:

SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
'DB
Maintenance: Syspro Co H'' (0x130A07F32DB37E41A29AA980DD8AD01D) -
Status:
Failed - Invoked on: 2006-05-22 12:59:48 - Message: The job failed.
The
Job
was invoked by User sa. The last step to run was step 1 (Step 1).

I have deleted the job and recreated it, but it still failed to run. I
have
an integrity check running on another db in the same SQL server, but
that
one
successfully completes.
Has anyone every encountered this?





.

Relevant Pages

  • Re: Adding another server instance to another hard drive?
    ... A disaster recovery plan will help you minimize data loss. ... If your computer crashes and/or you lose your SQL Server drive, ... get lucky with a successful attach of the database files if your database ... > drives to actively store data. ...
    (microsoft.public.sqlserver.server)
  • Re: Problem with Transaction backups
    ... You may need to drop and recreate the plan altogether if it doesn't save it by just editing it. ... Basically we have an SQL server that was running full backups and hourly ... a test database and tried the same thing and got the same results. ... Microsoft Analysis Services Client Tools 2005.090.3042.00 ...
    (microsoft.public.sqlserver.server)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Data integrity
    ... I do not expect 100% integrity, what I mean by that is "as ... mechanisms in the database and I have to use fingerprints ... SQL server provides guarantee against possible data damage ...
    (microsoft.public.sqlserver.security)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)