Integrity checks.....Attempt to repair any minor problems

Win2000sp4. SQL2k sp3
One server I have the option selected to Attempt to repair any minor
problems is checked on the Integrity checks. I know it is trying to repair
something due to the fact it is trying to place in single user mode and
can't due to connections.
My problem is that I have ran dbcc checkdb and no errors were found. So
what is exactly is it detecting and how do I detect the same? Certain trace
flags or option need to be set with dbcc checkdb?
TIA
CDThe DBCC CHECKDB has a parameter about how to repair the
error if it finds any. You can check BOL for details.
>--Original Message--
>Win2000sp4. SQL2k sp3
>One server I have the option selected to Attempt to
repair any minor
>problems is checked on the Integrity checks. I know it
is trying to repair
>something due to the fact it is trying to place in single
user mode and
>can't due to connections.
>My problem is that I have ran dbcc checkdb and no errors
were found. So
>what is exactly is it detecting and how do I detect the
same? Certain trace
>flags or option need to be set with dbcc checkdb?
>TIA
>CD
>
>.
>|||Remove the option to attempt to repair any minor
problems...it just causes problems with maintenance plans
and is not a good idea anyway. If you have errors in a dbcc
checkdb, you want to investigate the errors, find what the
root of the problem is and address the issue or issues
yourself before you would even consider using this option.
-Sue
On Wed, 12 Nov 2003 15:15:54 -0600, "CD"
<mcdye1@.hotmail.nospam.com> wrote:
>Win2000sp4. SQL2k sp3
>One server I have the option selected to Attempt to repair any minor
>problems is checked on the Integrity checks. I know it is trying to repair
>something due to the fact it is trying to place in single user mode and
>can't due to connections.
>My problem is that I have ran dbcc checkdb and no errors were found. So
>what is exactly is it detecting and how do I detect the same? Certain trace
>flags or option need to be set with dbcc checkdb?
>TIA
>CD
>|||Thanks for the replies, but you have missed the point. dbcc checkdb found
no errors.
The following leads me to believe that something was detected. But What?
How to confirm? Add switches to DBCC command? trace flag?
[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 'BaseQuery'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[1] Database BaseQuery: 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, 7 secs **
> On Wed, 12 Nov 2003 15:15:54 -0600, "CD"
> <mcdye1@.hotmail.nospam.com> wrote:
> >Win2000sp4. SQL2k sp3
> >
> >One server I have the option selected to Attempt to repair any minor
> >problems is checked on the Integrity checks. I know it is trying to
repair
> >something due to the fact it is trying to place in single user mode and
> >can't due to connections.
> >
> >My problem is that I have ran dbcc checkdb and no errors were found. So
> >what is exactly is it detecting and how do I detect the same? Certain
trace
> >flags or option need to be set with dbcc checkdb?
> >
> >TIA
> >CD
> >
>|||Don't believe I missed the point. When you run the integrity
check with that option, the maintenance plan attempts to put
the database in single user mode before it even runs the
integrity check. It doesn't run one version, detects an
error and then runs it again. It just attempts to put the
database in single user mode when using this option.
-Sue
On Thu, 13 Nov 2003 08:12:55 -0600, "CD"
<mcdye1@.hotmail.nospam.com> wrote:
>Thanks for the replies, but you have missed the point. dbcc checkdb found
>no errors.
>The following leads me to believe that something was detected. But What?
>How to confirm? Add switches to DBCC command? trace flag?
>[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 'BaseQuery'
>[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
>failed.
>[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
>[1] Database BaseQuery: 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, 7 secs **
>> On Wed, 12 Nov 2003 15:15:54 -0600, "CD"
>> <mcdye1@.hotmail.nospam.com> wrote:
>> >Win2000sp4. SQL2k sp3
>> >
>> >One server I have the option selected to Attempt to repair any minor
>> >problems is checked on the Integrity checks. I know it is trying to
>repair
>> >something due to the fact it is trying to place in single user mode and
>> >can't due to connections.
>> >
>> >My problem is that I have ran dbcc checkdb and no errors were found. So
>> >what is exactly is it detecting and how do I detect the same? Certain
>trace
>> >flags or option need to be set with dbcc checkdb?
>> >
>> >TIA
>> >CD
>> >
>|||SORRY!
Thank you for the reply....I was tunneled vision due to the next error
message. What excatly 2 hours different.|||No problem...it's not exactly all that intuitive in terms of
the error message and could be seen as having a consistency
problem when there really isn't one.
-Sue
On Thu, 13 Nov 2003 10:57:42 -0600, "CD"
<mcdye1@.hotmail.nospam.com> wrote:
>SORRY!
>Thank you for the reply....I was tunneled vision due to the next error
>message. What excatly 2 hours different.
>