Integrity Check/Optimization Check

As part of a Maintenance plan we have an Integrity check scheduled for 12:00
AM every Sunday Morning and an Optimization Check 1:00 AM every Sunday. I'm
noticing errors from one of of our Web Application that connects to a SQL
database. It has a process that runs every night 12:00 AM. This process
requires access to one of the Databses on the SQL server. The error is
basically a SQL error that states cannot open db, login failed. My question
is if the integrity check or optimization check would cause this. Does it
prevent anything from connecting to the database?The activities created from the Maintenance Plan wizard 'should' not keep
any user from connecting to the database. There may be some slowness, but
normal activity should not be impeded.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:D916B0EF-7158-4429-90B6-61CD9CB8B356@.microsoft.com...
> As part of a Maintenance plan we have an Integrity check scheduled for
> 12:00
> AM every Sunday Morning and an Optimization Check 1:00 AM every Sunday.
> I'm
> noticing errors from one of of our Web Application that connects to a SQL
> database. It has a process that runs every night 12:00 AM. This process
> requires access to one of the Databses on the SQL server. The error is
> basically a SQL error that states cannot open db, login failed. My
> question
> is if the integrity check or optimization check would cause this. Does it
> prevent anything from connecting to the database?|||George Schneider wrote:
> As part of a Maintenance plan we have an Integrity check scheduled for 12:
00
> AM every Sunday Morning and an Optimization Check 1:00 AM every Sunday. I
'm
> noticing errors from one of of our Web Application that connects to a SQL
> database. It has a process that runs every night 12:00 AM. This process
> requires access to one of the Databses on the SQL server. The error is
> basically a SQL error that states cannot open db, login failed. My questi
on
> is if the integrity check or optimization check would cause this. Does it
> prevent anything from connecting to the database?
If you've told the integrity check to attempt to fix any errors that it
finds, it will put the database into single-user/DBO only mode,
preventing other logins from connecting.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Oops, I forgot about that 'checkbox'. (Never use it and hope folks don't.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:456C78F0.4040101@.realsqlguy.com...
> George Schneider wrote:
> If you've told the integrity check to attempt to fix any errors that it
> finds, it will put the database into single-user/DBO only mode, preventing
> other logins from connecting.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Arnie Rowland wrote:
> Oops, I forgot about that 'checkbox'. (Never use it and hope folks don't.)
>
Ditto...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||If this is checked is the Databse put nto single user mode/DBO during the
scan or only if it finds an issue? If this is not checked how would I know
if there is an Integrity error? I would have to fix it myself instead of
having SQL automatically do this? How would I go about fixing integrity
issues then?
"Arnie Rowland" wrote:

> Oops, I forgot about that 'checkbox'. (Never use it and hope folks don't.)
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:456C78F0.4040101@.realsqlguy.com...
>
>|||George Schneider wrote:
> If this is checked is the Databse put nto single user mode/DBO during the
> scan or only if it finds an issue? If this is not checked how would I kno
w
> if there is an Integrity error? I would have to fix it myself instead of
> having SQL automatically do this? How would I go about fixing integrity
> issues then?
>
You're better off learning the various DBCC commands that are available
to you, as opposed to letting the maintenance plan auto-magically fix
things.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||You need to read up about the DBCC CHECKDB command. This is the very basic s
tarting point. When the
option is checked, the database is put in single user mode and then DBCC CHE
CKDB command is executed
with the REPAIR_FAST option, and the db is put back in multi user mode.
What we do is to *not* check this option, and have CHECKDB report the error
it finds, the job will
fail and you will be notified of the job failure so you can act.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:B5B7C210-DB54-43C0-AAEE-0FDF48CBFF28@.microsoft.com...[vbcol=seagreen]
> If this is checked is the Databse put nto single user mode/DBO during the
> scan or only if it finds an issue? If this is not checked how would I kno
w
> if there is an Integrity error? I would have to fix it myself instead of
> having SQL automatically do this? How would I go about fixing integrity
> issues then?
> "Arnie Rowland" wrote:
>|||Is that checkbox what is causing the databse to lock and not allow any user
login?
"Tracy McKibben" wrote:

> Arnie Rowland wrote:
> Ditto...
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||Yes.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:FD54EDB5-3346-4B64-AF4F-6602CF87F568@.microsoft.com...[vbcol=seagreen]
> Is that checkbox what is causing the databse to lock and not allow any use
r
> login?
> "Tracy McKibben" wrote:
>