intermittently my SSIS Packages which are run through the JOB are failing

Hi SSIS Guru's,

I am facing a very strange problem.

We have 2 Physical Servers (A and B) on which we have installed the SQL Server, one primary (A) and other as secondary (B). And there is a cluster (C) available to acces the running server. I have created some SSIS packages which we installed on the Server A (Primary), and created the job on the cluster server which initiates the SSIS packages, whcih are installed in the File System.

The problem i am facing is the some thing related to Connection time out. And interestingly i am not getting this error Always. Approxiamtely For Every 5 Times once it;s Failing. I am copying the errors Which i encountered in the different runs.

The thing i am confused is why i am not geting the error all the time? And Why am i getting this error all the time in a different data flow task. My SSIS Package structure is I have created one master package and 6 Child packages. I am getting the connection string for the Data base from the Configuration file which is defined in the XML File.

The connection string that i am using is

Data Source=<<server name>>;User ID=DOMAIN\user;Initial Catalog=DatabaseName;Provider=SQLNCLI.1;Integrated Security=SSPI;

*************************************************************************************************************************************

RUN 1 - Error
Executed as user: AMR\sys_calyp. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights

reserved. Started: 2:00:07 PM Error: 2007-09-15 14:02:35.92 Code: 0xC0202009 Source: ssis_emp Connection manager

"DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An

OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable to complete

login process due to delay in opening server connection". End Error Error: 2007-09-15 14:02:35.92 Code: 0xC020801C

Source: infr_char Get the Records from emp 1 [72] Description: SSIS Error Code

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager

"DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on

why the AcquireConnection method... The package execution fa... The step failed.

*************************************************************************************************************************************

*************************************************************************************************************************************

RUN 2 - Error
Message
Executed as user: AMR\sys_calyp. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights

reserved. Started: 9:15:01 AM Error: 2007-09-15 09:17:01.64 Code: 0xC0202009 Source: ssis_emp Connection manager

"DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An

OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable to complete

login process due to delay in opening server connection". End Error Error: 2007-09-15 09:17:01.64 Code: 0xC020801C

Source: Data Flow Task Get the Records from emp [473] Description: SSIS Error Code

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager

"DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on

why the AcquireConnection me... The package execution fa... The step failed.

*************************************************************************************************************************************

*************************************************************************************************************************************

Run -3 Error
Message
Executed as user: AMR\sys_calyp. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights

reserved. Started: 11:30:01 PM Error: 2007-09-14 23:32:21.28 Code: 0xC0202009 Source: ssis_dept Connection

manager "DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code:

0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable

to complete login process due to delay in opening server connection". End Error Error: 2007-09-14 23:32:21.28 Code:

0xC020801C Source: Data Flow Task Get the Records from dept [632] Description: SSIS Error Code

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager

"DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on

why the AcquireConnection method ... The package execution fa... The step failed.

*************************************************************************************************************************************

*************************************************************************************************************************************

Run - 4 Error

Message
Executed as user: AMR\sys_calyp. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights

reserved. Started: 11:00:02 PM Error: 2007-09-14 23:02:21.46 Code: 0xC0202009 Source: ssis_emp Connection

manager "DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code:

0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable

to complete login process due to delay in opening server connection". End Error Error: 2007-09-14 23:02:21.46 Code:

0xC020801C Source: infr_itm_char_val Get the Records from emp_master [1] Description: SSIS Error Code

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager

"DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on

why the AcquireCon... The package execution fa... The step failed.

*************************************************************************************************************************************

*************************************************************************************************************************************

Run -5 Error

Message
Executed as user: AMR\sys_calyp. ...Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp

1984-2005. All rights reserved. Started: 9:10:59 PM Error: 2007-09-14 21:12:23.25 Code: 0xC0202009 Source:

ssis_salgrade Connection manager "DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.

Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005

Description: "Unable to complete login process due to delay in opening server connection". End Error Error: 2007-09-14

21:12:23.25 Code: 0xC020801C Source: Data Flow Task - ssis_salgrade get salgrade [3227] Description: SSIS Error

Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager

"DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on

why the AcquireConnection method c. The step failed.

*************************************************************************************************************************************

I thought i found the solution my self... I changed the delay validation to all the packages to true and the problem dissappeared

intermittently my SSIS Packages which are run through the JOB are failing

Hi SSIS Guru's,

I am facing a very strange problem.

We have 2 Physical Servers (A and B) on which we have installed the SQL Server, one primary (A) and other as secondary (B). And there is a cluster (C) available to acces the running server. I have created some SSIS packages which we installed on the Server A (Primary), and created the job on the cluster server which initiates the SSIS packages, whcih are installed in the File System.

The problem i am facing is the some thing related to Connection time out. And interestingly i am not getting this error Always. Approxiamtely For Every 5 Times once it;s Failing. I am copying the errors Which i encountered in the different runs.

The thing i am confused is why i am not geting the error all the time? And Why am i getting this error all the time in a different data flow task. My SSIS Package structure is I have created one master package and 6 Child packages. I am getting the connection string for the Data base from the Configuration file which is defined in the XML File.

The connection string that i am using is

Data Source=<<server name>>;User ID=DOMAIN\user;Initial Catalog=DatabaseName;Provider=SQLNCLI.1;Integrated Security=SSPI;

*************************************************************************************************************************************

RUN 1 - Error
Executed as user: AMR\sys_calyp. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights

reserved. Started: 2:00:07 PM Error: 2007-09-15 14:02:35.92 Code: 0xC0202009 Source: ssis_emp Connection manager

"DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An

OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable to complete

login process due to delay in opening server connection". End Error Error: 2007-09-15 14:02:35.92 Code: 0xC020801C

Source: infr_char Get the Records from emp 1 [72] Description: SSIS Error Code

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager

"DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on

why the AcquireConnection method... The package execution fa... The step failed.

*************************************************************************************************************************************

*************************************************************************************************************************************

RUN 2 - Error
Message
Executed as user: AMR\sys_calyp. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights

reserved. Started: 9:15:01 AM Error: 2007-09-15 09:17:01.64 Code: 0xC0202009 Source: ssis_emp Connection manager

"DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An

OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable to complete

login process due to delay in opening server connection". End Error Error: 2007-09-15 09:17:01.64 Code: 0xC020801C

Source: Data Flow Task Get the Records from emp [473] Description: SSIS Error Code

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager

"DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on

why the AcquireConnection me... The package execution fa... The step failed.

*************************************************************************************************************************************

*************************************************************************************************************************************

Run -3 Error
Message
Executed as user: AMR\sys_calyp. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights

reserved. Started: 11:30:01 PM Error: 2007-09-14 23:32:21.28 Code: 0xC0202009 Source: ssis_dept Connection

manager "DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code:

0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable

to complete login process due to delay in opening server connection". End Error Error: 2007-09-14 23:32:21.28 Code:

0xC020801C Source: Data Flow Task Get the Records from dept [632] Description: SSIS Error Code

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager

"DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on

why the AcquireConnection method ... The package execution fa... The step failed.

*************************************************************************************************************************************

*************************************************************************************************************************************

Run - 4 Error

Message
Executed as user: AMR\sys_calyp. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights

reserved. Started: 11:00:02 PM Error: 2007-09-14 23:02:21.46 Code: 0xC0202009 Source: ssis_emp Connection

manager "DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code:

0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unable

to complete login process due to delay in opening server connection". End Error Error: 2007-09-14 23:02:21.46 Code:

0xC020801C Source: infr_itm_char_val Get the Records from emp_master [1] Description: SSIS Error Code

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager

"DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on

why the AcquireCon... The package execution fa... The step failed.

*************************************************************************************************************************************

*************************************************************************************************************************************

Run -5 Error

Message
Executed as user: AMR\sys_calyp. ...Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp

1984-2005. All rights reserved. Started: 9:10:59 PM Error: 2007-09-14 21:12:23.25 Code: 0xC0202009 Source:

ssis_salgrade Connection manager "DBCONNECTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.

Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005

Description: "Unable to complete login process due to delay in opening server connection". End Error Error: 2007-09-14

21:12:23.25 Code: 0xC020801C Source: Data Flow Task - ssis_salgrade get salgrade [3227] Description: SSIS Error

Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager

"DBCONNECTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on

why the AcquireConnection method c. The step failed.

*************************************************************************************************************************************

I thought i found the solution my self... I changed the delay validation to all the packages to true and the problem dissappeared

Integrity job error

Hi folks,

I created a job to check the integrity of my databases every week using SQL Server Maintenance Plan Wizard.
The job is failing every time...
For tb_basico database it works fine, but with the other one (tb_cep) it doesn't work...

Does someone have an idea to solve this problem?

The message is:

[1] Database tb_basico: Check Data and Index Linkage...

** Execution Time: 0 hrs, 0 mins, 11 secs **

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL Server Driver][SQL Server]Database state cannot be changed while other users are using the database 'tb_cep'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[2] Database tb_cep: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.

The following errors were found:

[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.
** Execution Time: 0 hrs, 0 mins, 1 secs **The problem is that other users are in the database while you are attempting to run the job created by the wizard. The wizard created job needs exclusive use of the database to complete the tasks you've asked it to do.

If you want to continue to run the wizard task, then I'd do an ALTER DATABASE mydb SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_4e5h.asp), then run the job created by the wizard. After the job completes, you can ALTER DATABASE mydb SET MULTI_USER to allow the users back into the database.

-PatP

Integrity checks keeps failing

Hi All,
I am driving myself crazy trying to debug this one. My Integrity check
keeps failing due to:
Test (m_freeCnt == freeCnt) failed. Values are 7798 and 8094.
And
Test (emptySlotCnt == 0) failed. Values are 1 and 0.
I have been researching this all morning. I ran a simple select on the
offending table and it turned out there where 2 columns that had a date that
went beyond the year 9999. I have nulled out the offending columns since
these dates are meaningless in the table. I can now run a select on this
table and return all rows, but the integrity check still fails for the same
reasons.
Can anyone please tell me how to fix this error? restoring the DB is out of
the question since i dont have a clean one without this issue. I am new to
this company and this job has been failing for long before I got here.
TIA,
Joe
jaylou
It is unclear, please provide DDL+ sample data+ keys to test the problem
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:F5825753-E60C-4062-9361-859BBFA5E9C0@.microsoft.com...
> Hi All,
> I am driving myself crazy trying to debug this one. My Integrity check
> keeps failing due to:
> Test (m_freeCnt == freeCnt) failed. Values are 7798 and 8094.
> And
> Test (emptySlotCnt == 0) failed. Values are 1 and 0.
> I have been researching this all morning. I ran a simple select on the
> offending table and it turned out there where 2 columns that had a date
> that
> went beyond the year 9999. I have nulled out the offending columns since
> these dates are meaningless in the table. I can now run a select on this
> table and return all rows, but the integrity check still fails for the
> same
> reasons.
> Can anyone please tell me how to fix this error? restoring the DB is out
> of
> the question since i dont have a clean one without this issue. I am new
> to
> this company and this job has been failing for long before I got here.
> TIA,
> Joe
>
|||Can you tell me how to send you that info?
"Uri Dimant" wrote:

> jaylou
> It is unclear, please provide DDL+ sample data+ keys to test the problem
>
>
>
>
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:F5825753-E60C-4062-9361-859BBFA5E9C0@.microsoft.com...
>
>
|||Post it here
CREATE TABEL tbl....
INSERT INTO tbl VALUES (.....
Desired result :
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:547DA248-751B-48FB-A5FC-B14D399554BC@.microsoft.com...[vbcol=seagreen]
> Can you tell me how to send you that info?
> "Uri Dimant" wrote:

Integrity checks keeps failing

Hi All,
I am driving myself crazy trying to debug this one. My Integrity check
keeps failing due to:
Test (m_freeCnt == freeCnt) failed. Values are 7798 and 8094.
And
Test (emptySlotCnt == 0) failed. Values are 1 and 0.
I have been researching this all morning. I ran a simple select on the
offending table and it turned out there where 2 columns that had a date that
went beyond the year 9999. I have nulled out the offending columns since
these dates are meaningless in the table. I can now run a select on this
table and return all rows, but the integrity check still fails for the same
reasons.
Can anyone please tell me how to fix this error? restoring the DB is out of
the question since i dont have a clean one without this issue. I am new to
this company and this job has been failing for long before I got here.
TIA,
Joejaylou
It is unclear, please provide DDL+ sample data+ keys to test the problem
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:F5825753-E60C-4062-9361-859BBFA5E9C0@.microsoft.com...
> Hi All,
> I am driving myself crazy trying to debug this one. My Integrity check
> keeps failing due to:
> Test (m_freeCnt == freeCnt) failed. Values are 7798 and 8094.
> And
> Test (emptySlotCnt == 0) failed. Values are 1 and 0.
> I have been researching this all morning. I ran a simple select on the
> offending table and it turned out there where 2 columns that had a date
> that
> went beyond the year 9999. I have nulled out the offending columns since
> these dates are meaningless in the table. I can now run a select on this
> table and return all rows, but the integrity check still fails for the
> same
> reasons.
> Can anyone please tell me how to fix this error? restoring the DB is out
> of
> the question since i dont have a clean one without this issue. I am new
> to
> this company and this job has been failing for long before I got here.
> TIA,
> Joe
>|||Can you tell me how to send you that info?
"Uri Dimant" wrote:

> jaylou
> It is unclear, please provide DDL+ sample data+ keys to test the problem
>
>
>
>
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:F5825753-E60C-4062-9361-859BBFA5E9C0@.microsoft.com...
>
>|||Post it here
CREATE TABEL tbl....
INSERT INTO tbl VALUES (.....
Desired result :
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:547DA248-751B-48FB-A5FC-B14D399554BC@.microsoft.com...[vbcol=seagreen]
> Can you tell me how to send you that info?
> "Uri Dimant" wrote:
>

Integrity checks keeps failing

Hi All,
I am driving myself crazy trying to debug this one. My Integrity check
keeps failing due to:
Test (m_freeCnt == freeCnt) failed. Values are 7798 and 8094.
And
Test (emptySlotCnt == 0) failed. Values are 1 and 0.
I have been researching this all morning. I ran a simple select on the
offending table and it turned out there where 2 columns that had a date that
went beyond the year 9999. I have nulled out the offending columns since
these dates are meaningless in the table. I can now run a select on this
table and return all rows, but the integrity check still fails for the same
reasons.
Can anyone please tell me how to fix this error? restoring the DB is out of
the question since i dont have a clean one without this issue. I am new to
this company and this job has been failing for long before I got here.
TIA,
Joejaylou
It is unclear, please provide DDL+ sample data+ keys to test the problem
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:F5825753-E60C-4062-9361-859BBFA5E9C0@.microsoft.com...
> Hi All,
> I am driving myself crazy trying to debug this one. My Integrity check
> keeps failing due to:
> Test (m_freeCnt == freeCnt) failed. Values are 7798 and 8094.
> And
> Test (emptySlotCnt == 0) failed. Values are 1 and 0.
> I have been researching this all morning. I ran a simple select on the
> offending table and it turned out there where 2 columns that had a date
> that
> went beyond the year 9999. I have nulled out the offending columns since
> these dates are meaningless in the table. I can now run a select on this
> table and return all rows, but the integrity check still fails for the
> same
> reasons.
> Can anyone please tell me how to fix this error? restoring the DB is out
> of
> the question since i dont have a clean one without this issue. I am new
> to
> this company and this job has been failing for long before I got here.
> TIA,
> Joe
>|||Can you tell me how to send you that info?
"Uri Dimant" wrote:
> jaylou
> It is unclear, please provide DDL+ sample data+ keys to test the problem
>
>
>
>
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:F5825753-E60C-4062-9361-859BBFA5E9C0@.microsoft.com...
> > Hi All,
> > I am driving myself crazy trying to debug this one. My Integrity check
> > keeps failing due to:
> > Test (m_freeCnt == freeCnt) failed. Values are 7798 and 8094.
> > And
> > Test (emptySlotCnt == 0) failed. Values are 1 and 0.
> >
> > I have been researching this all morning. I ran a simple select on the
> > offending table and it turned out there where 2 columns that had a date
> > that
> > went beyond the year 9999. I have nulled out the offending columns since
> > these dates are meaningless in the table. I can now run a select on this
> > table and return all rows, but the integrity check still fails for the
> > same
> > reasons.
> >
> > Can anyone please tell me how to fix this error? restoring the DB is out
> > of
> > the question since i dont have a clean one without this issue. I am new
> > to
> > this company and this job has been failing for long before I got here.
> >
> > TIA,
> > Joe
> >
>
>|||Post it here
CREATE TABEL tbl....
INSERT INTO tbl VALUES (.....
Desired result :
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:547DA248-751B-48FB-A5FC-B14D399554BC@.microsoft.com...
> Can you tell me how to send you that info?
> "Uri Dimant" wrote:
>> jaylou
>> It is unclear, please provide DDL+ sample data+ keys to test the problem
>>
>>
>>
>>
>> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
>> news:F5825753-E60C-4062-9361-859BBFA5E9C0@.microsoft.com...
>> > Hi All,
>> > I am driving myself crazy trying to debug this one. My Integrity check
>> > keeps failing due to:
>> > Test (m_freeCnt == freeCnt) failed. Values are 7798 and 8094.
>> > And
>> > Test (emptySlotCnt == 0) failed. Values are 1 and 0.
>> >
>> > I have been researching this all morning. I ran a simple select on the
>> > offending table and it turned out there where 2 columns that had a date
>> > that
>> > went beyond the year 9999. I have nulled out the offending columns
>> > since
>> > these dates are meaningless in the table. I can now run a select on
>> > this
>> > table and return all rows, but the integrity check still fails for the
>> > same
>> > reasons.
>> >
>> > Can anyone please tell me how to fix this error? restoring the DB is
>> > out
>> > of
>> > the question since i dont have a clean one without this issue. I am
>> > new
>> > to
>> > this company and this job has been failing for long before I got here.
>> >
>> > TIA,
>> > Joe
>> >
>>

Integrity Checks job failing

Hi,

SQl Server 7

I have Daily User DB Integrity Checks job running daily
From past 2 days i am getting below error.

[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 35 consistency errors in table 'Prod_Hist' (object ID 2098106515).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 99 consistency errors in database 'Ucatalog'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Ucatalog repair_fast).
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Please suggest..

Thanks in Advance
AdilHi,

SQl Server 7

I have Daily User DB Integrity Checks job running daily
From past 2 days i am getting below error.

[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 35 consistency errors in table 'Prod_Hist' (object ID 2098106515).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 99 consistency errors in database 'Ucatalog'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Ucatalog repair_fast).
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.


Please suggest..

Thanks in Advance
Adil

1. Contact your DBA with the stated information and ask for his help or
2. Fix the table and database corruption ... either by running checkdb with the repair option stated or restore from a previous backup. Checkdb is telling you that you will probably lose data by allowing it to repair the corruption ... be prepared.

Integrity Checks continue to fail

I have a Maintenance plan schedule on one my dev databases, and I'm
continually getting notices that it is failing. Here is the report that I
get:
Starting maintenance plan 'CRMDEV DB Maintenance Plan' on 1/11/2007 8:00:00
PM
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Database state cannot be changed while other u
sers
are using the database 'CRMDEV'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE st
atement
failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption comma
nd failed.
[1] Database CRMDEV: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs
to
be in single user mode.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement
not
processed. Database needs to be in single user mode.
** Execution Time: 0 hrs, 0 mins, 1 secs **
End of maintenance plan 'CRMDEV DB Maintenance Plan' on 1/11/2007 8:00:01 PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
How do I put a database in "single-user" mode to run an Integrity check?
Thanks,
SaraSaral6978 wrote:
> I have a Maintenance plan schedule on one my dev databases, and I'm
> continually getting notices that it is failing. Here is the report that I
> get:
> Starting maintenance plan 'CRMDEV DB Maintenance Plan' on 1/11/2007 8:00:0
0 PM
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft]
[ODBC SQL
> Server Driver][SQL Server]Database state cannot be changed while other
users
> are using the database 'CRMDEV'
> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE
statement
> failed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption com
mand failed.
> [1] Database CRMDEV: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft]
[ODBC SQL
> Server Driver][SQL Server]Repair statement not processed. Database nee
ds to
> be in single user mode.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statemen
t not
> processed. Database needs to be in single user mode.
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> End of maintenance plan 'CRMDEV DB Maintenance Plan' on 1/11/2007 8:00:01
PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
> How do I put a database in "single-user" mode to run an Integrity check?
> Thanks,
> Sara
>
The maintenance plan is attempting to put the DB in single user mode
(that's what the failing ALTER DATABASE statement is doing). It's
failing because someone/something has a connection that can't be terminated.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||A database does NOT need to be in the single user mode to perform integrity
checks. But it does need to be in the single user mode to attempt any repair
.
Automated repair is a dangerous business, and I'd suggest that you modify
your maintenance plan to disable it. In addition, it's not rare for a
database to be left in the single user mode after the repair is done, thus
preventing others from using the database until you intervene.
Linchi
"Saral6978" wrote:

> I have a Maintenance plan schedule on one my dev databases, and I'm
> continually getting notices that it is failing. Here is the report that I
> get:
> Starting maintenance plan 'CRMDEV DB Maintenance Plan' on 1/11/2007 8:00:0
0 PM
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft]
[ODBC SQL
> Server Driver][SQL Server]Database state cannot be changed while other
users
> are using the database 'CRMDEV'
> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE
statement
> failed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption com
mand failed.
> [1] Database CRMDEV: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft]
[ODBC SQL
> Server Driver][SQL Server]Repair statement not processed. Database nee
ds to
> be in single user mode.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statemen
t not
> processed. Database needs to be in single user mode.
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> End of maintenance plan 'CRMDEV DB Maintenance Plan' on 1/11/2007 8:00:01
PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
> How do I put a database in "single-user" mode to run an Integrity check?
> Thanks,
> Sara
>|||Linchi - thank you so much for your suggestion...I will disable the automati
c
repair...thanks!
"Linchi Shea" wrote:
[vbcol=seagreen]
> A database does NOT need to be in the single user mode to perform integrit
y
> checks. But it does need to be in the single user mode to attempt any repa
ir.
> Automated repair is a dangerous business, and I'd suggest that you modify
> your maintenance plan to disable it. In addition, it's not rare for a
> database to be left in the single user mode after the repair is done, thus
> preventing others from using the database until you intervene.
> Linchi
> "Saral6978" wrote:
>|||Okay - I just unchecked the "Attempt to repair" box, ran the Integrity check
,
and it was successful.
Thank you so much!
"Linchi Shea" wrote:
[vbcol=seagreen]
> A database does NOT need to be in the single user mode to perform integrit
y
> checks. But it does need to be in the single user mode to attempt any repa
ir.
> Automated repair is a dangerous business, and I'd suggest that you modify
> your maintenance plan to disable it. In addition, it's not rare for a
> database to be left in the single user mode after the repair is done, thus
> preventing others from using the database until you intervene.
> Linchi
> "Saral6978" wrote:
>

Integrity Checks continue to fail

I have a Maintenance plan schedule on one my dev databases, and I'm
continually getting notices that it is failing. Here is the report that I
get:
Starting maintenance plan 'CRMDEV DB Maintenance Plan' on 1/11/2007 8:00:00 PM
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL
Server Driver][SQL Server]Database state cannot be changed while other users
are using the database 'CRMDEV'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[1] Database CRMDEV: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs to
be in single user mode.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
processed. Database needs to be in single user mode.
** Execution Time: 0 hrs, 0 mins, 1 secs **
End of maintenance plan 'CRMDEV DB Maintenance Plan' on 1/11/2007 8:00:01 PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
How do I put a database in "single-user" mode to run an Integrity check?
Thanks,
Sara
Saral6978 wrote:
> I have a Maintenance plan schedule on one my dev databases, and I'm
> continually getting notices that it is failing. Here is the report that I
> get:
> Starting maintenance plan 'CRMDEV DB Maintenance Plan' on 1/11/2007 8:00:00 PM
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL
> Server Driver][SQL Server]Database state cannot be changed while other users
> are using the database 'CRMDEV'
> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
> failed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> [1] Database CRMDEV: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL
> Server Driver][SQL Server]Repair statement not processed. Database needs to
> be in single user mode.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
> processed. Database needs to be in single user mode.
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> End of maintenance plan 'CRMDEV DB Maintenance Plan' on 1/11/2007 8:00:01 PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
> How do I put a database in "single-user" mode to run an Integrity check?
> Thanks,
> Sara
>
The maintenance plan is attempting to put the DB in single user mode
(that's what the failing ALTER DATABASE statement is doing). It's
failing because someone/something has a connection that can't be terminated.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||A database does NOT need to be in the single user mode to perform integrity
checks. But it does need to be in the single user mode to attempt any repair.
Automated repair is a dangerous business, and I'd suggest that you modify
your maintenance plan to disable it. In addition, it's not rare for a
database to be left in the single user mode after the repair is done, thus
preventing others from using the database until you intervene.
Linchi
"Saral6978" wrote:

> I have a Maintenance plan schedule on one my dev databases, and I'm
> continually getting notices that it is failing. Here is the report that I
> get:
> Starting maintenance plan 'CRMDEV DB Maintenance Plan' on 1/11/2007 8:00:00 PM
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL
> Server Driver][SQL Server]Database state cannot be changed while other users
> are using the database 'CRMDEV'
> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
> failed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> [1] Database CRMDEV: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL
> Server Driver][SQL Server]Repair statement not processed. Database needs to
> be in single user mode.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
> processed. Database needs to be in single user mode.
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> End of maintenance plan 'CRMDEV DB Maintenance Plan' on 1/11/2007 8:00:01 PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
> How do I put a database in "single-user" mode to run an Integrity check?
> Thanks,
> Sara
>
|||Linchi - thank you so much for your suggestion...I will disable the automatic
repair...thanks!
"Linchi Shea" wrote:
[vbcol=seagreen]
> A database does NOT need to be in the single user mode to perform integrity
> checks. But it does need to be in the single user mode to attempt any repair.
> Automated repair is a dangerous business, and I'd suggest that you modify
> your maintenance plan to disable it. In addition, it's not rare for a
> database to be left in the single user mode after the repair is done, thus
> preventing others from using the database until you intervene.
> Linchi
> "Saral6978" wrote:
|||Okay - I just unchecked the "Attempt to repair" box, ran the Integrity check,
and it was successful.
Thank you so much!
"Linchi Shea" wrote:
[vbcol=seagreen]
> A database does NOT need to be in the single user mode to perform integrity
> checks. But it does need to be in the single user mode to attempt any repair.
> Automated repair is a dangerous business, and I'd suggest that you modify
> your maintenance plan to disable it. In addition, it's not rare for a
> database to be left in the single user mode after the repair is done, thus
> preventing others from using the database until you intervene.
> Linchi
> "Saral6978" wrote:

Integrity Check Failure

DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
Log backup and Optimizations are successful. I can’t determine if it’s
failing to run or if it’s running
and finding a problem. The logs are not indicating any reasons for failure.
Integrity check is successful on other DB’s. Thanks for being there to help.
1. Define a report file for the plan and check that report file for error messages.
2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
3. http://www.karaszi.com/SQLServer/inf...suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> Log backup and Optimizations are successful. I can’t determine if it’s
> failing to run or if it’s running
> and finding a problem. The logs are not indicating any reasons for failure.
> Integrity check is successful on other DB’s. Thanks for being there to help.
>
|||Thanks Tibor. Can you direct me to a location that indicates the procedure for
defining a report?
"Tibor Karaszi" wrote:

> 1. Define a report file for the plan and check that report file for error messages.
> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> 3. http://www.karaszi.com/SQLServer/inf...suspect_db.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
>
|||EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
this option. You can also right-click an existing plan and open (something like) history and try to
find the error messages there. I don't use maint plans, so it is a little bit sketchy...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...[vbcol=seagreen]
> Thanks Tibor. Can you direct me to a location that indicates the procedure for
> defining a report?
> "Tibor Karaszi" wrote:
|||Thanks for your help
"Tibor Karaszi" wrote:

> EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
> this option. You can also right-click an existing plan and open (something like) history and try to
> find the error messages there. I don't use maint plans, so it is a little bit sketchy...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
>

Integrity Check Failure

DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
Log backup and Optimizations are successful. I can’t determine if it’s
failing to run or if it’s running
and finding a problem. The logs are not indicating any reasons for failure.
Integrity check is successful on other DB’s. Thanks for being there to hel
p.1. Define a report file for the plan and check that report file for error me
ssages.
2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
3. http://www.karaszi.com/SQLServer/in..._suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> Log backup and Optimizations are successful. I can’t determine if it’s
> failing to run or if it’s running
> and finding a problem. The logs are not indicating any reasons for failure
.
> Integrity check is successful on other DB’s. Thanks for being there to h
elp.
>|||Thanks Tibor. Can you direct me to a location that indicates the procedure f
or
defining a report?
"Tibor Karaszi" wrote:

> 1. Define a report file for the plan and check that report file for error
messages.
> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> 3. http://www.karaszi.com/SQLServer/in..._suspect_db.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
>|||EM, Management, Maintenance Plans, right-click your plan to open it. The rig
ht-most ( think) tab has
this option. You can also right-click an existing plan and open (something l
ike) history and try to
find the error messages there. I don't use maint plans, so it is a little bi
t sketchy...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...[vbcol=seagreen]
> Thanks Tibor. Can you direct me to a location that indicates the procedure
for
> defining a report?
> "Tibor Karaszi" wrote:
>|||Thanks for your help
"Tibor Karaszi" wrote:

> EM, Management, Maintenance Plans, right-click your plan to open it. The r
ight-most ( think) tab has
> this option. You can also right-click an existing plan and open (something
like) history and try to
> find the error messages there. I don't use maint plans, so it is a little
bit sketchy...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
>

Integrity Check Failure

DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
Log backup and Optimizations are successful. I canâ't determine if itâ's
failing to run or if itâ's running
and finding a problem. The logs are not indicating any reasons for failure.
Integrity check is successful on other DBâ's. Thanks for being there to help.1. Define a report file for the plan and check that report file for error messages.
2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> Log backup and Optimizations are successful. I canâ't determine if itâ's
> failing to run or if itâ's running
> and finding a problem. The logs are not indicating any reasons for failure.
> Integrity check is successful on other DBâ's. Thanks for being there to help.
>|||Thanks Tibor. Can you direct me to a location that indicates the procedure for
defining a report?
"Tibor Karaszi" wrote:
> 1. Define a report file for the plan and check that report file for error messages.
> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> > Log backup and Optimizations are successful. I canâ't determine if itâ's
> > failing to run or if itâ's running
> > and finding a problem. The logs are not indicating any reasons for failure.
> > Integrity check is successful on other DBâ's. Thanks for being there to help.
> >
>|||EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
this option. You can also right-click an existing plan and open (something like) history and try to
find the error messages there. I don't use maint plans, so it is a little bit sketchy...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
> Thanks Tibor. Can you direct me to a location that indicates the procedure for
> defining a report?
> "Tibor Karaszi" wrote:
>> 1. Define a report file for the plan and check that report file for error messages.
>> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
>> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
>> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
>> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
>> > Log backup and Optimizations are successful. I canâ't determine if itâ's
>> > failing to run or if itâ's running
>> > and finding a problem. The logs are not indicating any reasons for failure.
>> > Integrity check is successful on other DBâ's. Thanks for being there to help.
>> >
>>|||Thanks for your help
"Tibor Karaszi" wrote:
> EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
> this option. You can also right-click an existing plan and open (something like) history and try to
> find the error messages there. I don't use maint plans, so it is a little bit sketchy...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
> > Thanks Tibor. Can you direct me to a location that indicates the procedure for
> > defining a report?
> >
> > "Tibor Karaszi" wrote:
> >
> >> 1. Define a report file for the plan and check that report file for error messages.
> >>
> >> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> >>
> >> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> >> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> >> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> >> > Log backup and Optimizations are successful. I canâ't determine if itâ's
> >> > failing to run or if itâ's running
> >> > and finding a problem. The logs are not indicating any reasons for failure.
> >> > Integrity check is successful on other DBâ's. Thanks for being there to help.
> >> >
> >>
> >>
>