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 question
> 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 the
> 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 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?
>
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
|||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
>