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
>
Showing posts with label optimization. Show all posts
Showing posts with label optimization. Show all posts
Wednesday, March 7, 2012
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:
>
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:
>
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:
>> 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|||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:
> >> 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
>
>|||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|||You need to read up about the DBCC CHECKDB command. This is the very basic starting point. When the
option is checked, the database is put in single user mode and then DBCC CHECKDB 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...
> 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:
>> >> 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
>>|||Is that checkbox what is causing the databse to lock and not allow any user
login?
"Tracy McKibben" wrote:
> 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
>|||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...
> Is that checkbox what is causing the databse to lock and not allow any user
> login?
> "Tracy McKibben" wrote:
>> 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
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:
>> 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|||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:
> >> 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
>
>|||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|||You need to read up about the DBCC CHECKDB command. This is the very basic starting point. When the
option is checked, the database is put in single user mode and then DBCC CHECKDB 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...
> 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:
>> >> 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
>>|||Is that checkbox what is causing the databse to lock and not allow any user
login?
"Tracy McKibben" wrote:
> 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
>|||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...
> Is that checkbox what is causing the databse to lock and not allow any user
> login?
> "Tracy McKibben" wrote:
>> 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
Integrity check and optimization job failed
I found the following error in my maintenance plan please help me on this
Under maintenace plan history i found this error:-
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
and jobs failed with following error
i found this error in job history of optimization & integrity check jobs:-
Executed as user: XXXX\admin. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
Please help me find out the solution
Thanks in advance
Regards,
Sumitdo not use maintenance plans. setup your own jobs for this stuff. easier to troubleshoot and you have more granular control.|||This error isn't caused by the maintenance plan, but rather occurs within the job the maintenance plan creates. The error is generated by UPDATE STATISTICS, and in my experience is related to attempts to update the stats on a table that is used to record or maintain table statistics (such as a table within the msdb database). Unfortunately, I have not been able to reliably reproduce the problem in order to debug it. When I run UPDATE STATS on the offending table a second time, it always completes succesfully. So far, it has not bothered my enough to make me want to delve into it any deeper.
Under maintenace plan history i found this error:-
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
and jobs failed with following error
i found this error in job history of optimization & integrity check jobs:-
Executed as user: XXXX\admin. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
Please help me find out the solution
Thanks in advance
Regards,
Sumitdo not use maintenance plans. setup your own jobs for this stuff. easier to troubleshoot and you have more granular control.|||This error isn't caused by the maintenance plan, but rather occurs within the job the maintenance plan creates. The error is generated by UPDATE STATISTICS, and in my experience is related to attempts to update the stats on a table that is used to record or maintain table statistics (such as a table within the msdb database). Unfortunately, I have not been able to reliably reproduce the problem in order to debug it. When I run UPDATE STATS on the offending table a second time, it always completes succesfully. So far, it has not bothered my enough to make me want to delve into it any deeper.
Integrity and Optimization failures
Hi All-
I have a websense log database that the Optimization and Integrity check
jobs fail on. My problem is I cannot determine WHY exactly these jobs have
failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
appears to be a problem. I even tried running the optimization and integrit
y
checks while the database is in single user mode to no avail. How can I A.
determine what the problem is and B. correct it?
Thank You for your help in advance!
--GREENTHUMB--I suggest you specify a report file for the Maint plan and check for specifi
c error messages in that
report file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> Hi All-
> I have a websense log database that the Optimization and Integrity check
> jobs fail on. My problem is I cannot determine WHY exactly these jobs hav
e
> failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> appears to be a problem. I even tried running the optimization and integr
ity
> checks while the database is in single user mode to no avail. How can I A
.
> determine what the problem is and B. correct it?
> Thank You for your help in advance!
> --GREENTHUMB--|||Hi Tibor-
I have enabled writing to the Event Log and notification to my e-mail but
the error message is extremely vague:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 4/20/2005
Time: 10:13:13 AM
User: N/A
Computer: XXXXXXXXX
Description:
SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was ste
p
1 (Step 1).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"Tibor Karaszi" wrote:
> I suggest you specify a report file for the Maint plan and check for speci
fic error messages in that
> report file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
>
>|||The vagueness of that message is exactly why I suggested to specify in the m
aint plan to create a
report file. In there you will find the error messages from SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...[vbcol=seagreen]
> Hi Tibor-
> I have enabled writing to the Event Log and notification to my e-mail but
> the error message is extremely vague:
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 4/20/2005
> Time: 10:13:13 AM
> User: N/A
> Computer: XXXXXXXXX
> Description:
> SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
> 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
> Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed
.
> The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was s
tep
> 1 (Step 1).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> "Tibor Karaszi" wrote:
>|||Hi Tibor-
Okay - I enabled the reports and the error given is "database is already
open and can only have one user at a time". However, I checked Single User
Mode *AND* even detached and re-attached and set to Single User to no avail.
I also checked Process info. but that database was not being accessed. Any
ideas?
Thank You!!!
--GREENTHUMB--
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'ORCRASV005' as 'GWN\services' (trusted)
Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
6:35:03 PM
[1] Database wslogdb55: Check Data and Index Linkage...
[Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is al
ready
open and can only have one user at a time.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb
55' is
already open and can only have one user at a time.
** Execution Time: 0 hrs, 0 mins, 4 secs **
End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005 6:35:07
PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
"Tibor Karaszi" wrote:
> The vagueness of that message is exactly why I suggested to specify in the
maint plan to create a
> report file. In there you will find the error messages from SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
>
>|||You need to uncheck the checkbox in the maintenance plan that says to
"Repair minor problems" and it should work fine. When you have that checked
it tries to put the db in single user mode and if it can't it errors. You
really don't want it repairing things on it's own anyway.
Andrew J. Kelly SQL MVP
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:432B45E0-DA60-455B-AA32-84EC8FCC3700@.microsoft.com...[vbcol=seagreen]
> Hi Tibor-
> Okay - I enabled the reports and the error given is "database is already
> open and can only have one user at a time". However, I checked Single
> User
> Mode *AND* even detached and re-attached and set to Single User to no
> avail.
> I also checked Process info. but that database was not being accessed.
> Any
> ideas?
> Thank You!!!
> --GREENTHUMB--
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'ORCRASV005' as 'GWN\services' (trusted)
> Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:03 PM
> [1] Database wslogdb55: Check Data and Index Linkage...
> [Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is
already
> open and can only have one user at a time.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslog
db55' is
> already open and can only have one user at a time.
> ** Execution Time: 0 hrs, 0 mins, 4 secs **
> End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:07
> PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> "Tibor Karaszi" wrote:
>|||Since this job is checking database integrity, is this always a good
practice?
I have a websense log database that the Optimization and Integrity check
jobs fail on. My problem is I cannot determine WHY exactly these jobs have
failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
appears to be a problem. I even tried running the optimization and integrit
y
checks while the database is in single user mode to no avail. How can I A.
determine what the problem is and B. correct it?
Thank You for your help in advance!
--GREENTHUMB--I suggest you specify a report file for the Maint plan and check for specifi
c error messages in that
report file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> Hi All-
> I have a websense log database that the Optimization and Integrity check
> jobs fail on. My problem is I cannot determine WHY exactly these jobs hav
e
> failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> appears to be a problem. I even tried running the optimization and integr
ity
> checks while the database is in single user mode to no avail. How can I A
.
> determine what the problem is and B. correct it?
> Thank You for your help in advance!
> --GREENTHUMB--|||Hi Tibor-
I have enabled writing to the Event Log and notification to my e-mail but
the error message is extremely vague:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 4/20/2005
Time: 10:13:13 AM
User: N/A
Computer: XXXXXXXXX
Description:
SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was ste
p
1 (Step 1).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"Tibor Karaszi" wrote:
> I suggest you specify a report file for the Maint plan and check for speci
fic error messages in that
> report file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
>
>|||The vagueness of that message is exactly why I suggested to specify in the m
aint plan to create a
report file. In there you will find the error messages from SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...[vbcol=seagreen]
> Hi Tibor-
> I have enabled writing to the Event Log and notification to my e-mail but
> the error message is extremely vague:
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 4/20/2005
> Time: 10:13:13 AM
> User: N/A
> Computer: XXXXXXXXX
> Description:
> SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
> 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
> Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed
.
> The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was s
tep
> 1 (Step 1).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> "Tibor Karaszi" wrote:
>|||Hi Tibor-
Okay - I enabled the reports and the error given is "database is already
open and can only have one user at a time". However, I checked Single User
Mode *AND* even detached and re-attached and set to Single User to no avail.
I also checked Process info. but that database was not being accessed. Any
ideas?
Thank You!!!
--GREENTHUMB--
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'ORCRASV005' as 'GWN\services' (trusted)
Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
6:35:03 PM
[1] Database wslogdb55: Check Data and Index Linkage...
[Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is al
ready
open and can only have one user at a time.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb
55' is
already open and can only have one user at a time.
** Execution Time: 0 hrs, 0 mins, 4 secs **
End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005 6:35:07
PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
"Tibor Karaszi" wrote:
> The vagueness of that message is exactly why I suggested to specify in the
maint plan to create a
> report file. In there you will find the error messages from SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
>
>|||You need to uncheck the checkbox in the maintenance plan that says to
"Repair minor problems" and it should work fine. When you have that checked
it tries to put the db in single user mode and if it can't it errors. You
really don't want it repairing things on it's own anyway.
Andrew J. Kelly SQL MVP
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:432B45E0-DA60-455B-AA32-84EC8FCC3700@.microsoft.com...[vbcol=seagreen]
> Hi Tibor-
> Okay - I enabled the reports and the error given is "database is already
> open and can only have one user at a time". However, I checked Single
> User
> Mode *AND* even detached and re-attached and set to Single User to no
> avail.
> I also checked Process info. but that database was not being accessed.
> Any
> ideas?
> Thank You!!!
> --GREENTHUMB--
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'ORCRASV005' as 'GWN\services' (trusted)
> Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:03 PM
> [1] Database wslogdb55: Check Data and Index Linkage...
> [Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is
already
> open and can only have one user at a time.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslog
db55' is
> already open and can only have one user at a time.
> ** Execution Time: 0 hrs, 0 mins, 4 secs **
> End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:07
> PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> "Tibor Karaszi" wrote:
>|||Since this job is checking database integrity, is this always a good
practice?
Integrity and Optimization failures
Hi All-
I have a websense log database that the Optimization and Integrity check
jobs fail on. My problem is I cannot determine WHY exactly these jobs have
failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
appears to be a problem. I even tried running the optimization and integrity
checks while the database is in single user mode to no avail. How can I A.
determine what the problem is and B. correct it?
Thank You for your help in advance!
--GREENTHUMB--I suggest you specify a report file for the Maint plan and check for specific error messages in that
report file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> Hi All-
> I have a websense log database that the Optimization and Integrity check
> jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> appears to be a problem. I even tried running the optimization and integrity
> checks while the database is in single user mode to no avail. How can I A.
> determine what the problem is and B. correct it?
> Thank You for your help in advance!
> --GREENTHUMB--|||Hi Tibor-
I have enabled writing to the Event Log and notification to my e-mail but
the error message is extremely vague:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 4/20/2005
Time: 10:13:13 AM
User: N/A
Computer: XXXXXXXXX
Description:
SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
1 (Step 1).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"Tibor Karaszi" wrote:
> I suggest you specify a report file for the Maint plan and check for specific error messages in that
> report file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> > Hi All-
> >
> > I have a websense log database that the Optimization and Integrity check
> > jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> > appears to be a problem. I even tried running the optimization and integrity
> > checks while the database is in single user mode to no avail. How can I A.
> > determine what the problem is and B. correct it?
> >
> > Thank You for your help in advance!
> >
> > --GREENTHUMB--
>
>|||The vagueness of that message is exactly why I suggested to specify in the maint plan to create a
report file. In there you will find the error messages from SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
> Hi Tibor-
> I have enabled writing to the Event Log and notification to my e-mail but
> the error message is extremely vague:
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 4/20/2005
> Time: 10:13:13 AM
> User: N/A
> Computer: XXXXXXXXX
> Description:
> SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
> 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
> Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
> The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
> 1 (Step 1).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> "Tibor Karaszi" wrote:
>> I suggest you specify a report file for the Maint plan and check for specific error messages in
>> that
>> report file.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
>> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
>> > Hi All-
>> >
>> > I have a websense log database that the Optimization and Integrity check
>> > jobs fail on. My problem is I cannot determine WHY exactly these jobs have
>> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
>> > appears to be a problem. I even tried running the optimization and integrity
>> > checks while the database is in single user mode to no avail. How can I A.
>> > determine what the problem is and B. correct it?
>> >
>> > Thank You for your help in advance!
>> >
>> > --GREENTHUMB--
>>|||Hi Tibor-
Okay - I enabled the reports and the error given is "database is already
open and can only have one user at a time". However, I checked Single User
Mode *AND* even detached and re-attached and set to Single User to no avail.
I also checked Process info. but that database was not being accessed. Any
ideas?
Thank You!!!
--GREENTHUMB--
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'ORCRASV005' as 'GWN\services' (trusted)
Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
6:35:03 PM
[1] Database wslogdb55: Check Data and Index Linkage...
[Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is already
open and can only have one user at a time.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb55' is
already open and can only have one user at a time.
** Execution Time: 0 hrs, 0 mins, 4 secs **
End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005 6:35:07
PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
"Tibor Karaszi" wrote:
> The vagueness of that message is exactly why I suggested to specify in the maint plan to create a
> report file. In there you will find the error messages from SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
> > Hi Tibor-
> >
> > I have enabled writing to the Event Log and notification to my e-mail but
> > the error message is extremely vague:
> >
> > Event Type: Warning
> > Event Source: SQLSERVERAGENT
> > Event Category: Job Engine
> > Event ID: 208
> > Date: 4/20/2005
> > Time: 10:13:13 AM
> > User: N/A
> > Computer: XXXXXXXXX
> > Description:
> > SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
> > 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
> > Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
> > The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
> > 1 (Step 1).
> >
> > For more information, see Help and Support Center at
> > http://go.microsoft.com/fwlink/events.asp.
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> I suggest you specify a report file for the Maint plan and check for specific error messages in
> >> that
> >> report file.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> >> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> >> > Hi All-
> >> >
> >> > I have a websense log database that the Optimization and Integrity check
> >> > jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> >> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> >> > appears to be a problem. I even tried running the optimization and integrity
> >> > checks while the database is in single user mode to no avail. How can I A.
> >> > determine what the problem is and B. correct it?
> >> >
> >> > Thank You for your help in advance!
> >> >
> >> > --GREENTHUMB--
> >>
> >>
> >>
>
>|||You need to uncheck the checkbox in the maintenance plan that says to
"Repair minor problems" and it should work fine. When you have that checked
it tries to put the db in single user mode and if it can't it errors. You
really don't want it repairing things on it's own anyway.
--
Andrew J. Kelly SQL MVP
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:432B45E0-DA60-455B-AA32-84EC8FCC3700@.microsoft.com...
> Hi Tibor-
> Okay - I enabled the reports and the error given is "database is already
> open and can only have one user at a time". However, I checked Single
> User
> Mode *AND* even detached and re-attached and set to Single User to no
> avail.
> I also checked Process info. but that database was not being accessed.
> Any
> ideas?
> Thank You!!!
> --GREENTHUMB--
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'ORCRASV005' as 'GWN\services' (trusted)
> Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:03 PM
> [1] Database wslogdb55: Check Data and Index Linkage...
> [Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is already
> open and can only have one user at a time.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb55' is
> already open and can only have one user at a time.
> ** Execution Time: 0 hrs, 0 mins, 4 secs **
> End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:07
> PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> "Tibor Karaszi" wrote:
>> The vagueness of that message is exactly why I suggested to specify in
>> the maint plan to create a
>> report file. In there you will find the error messages from SQL Server.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
>> news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
>> > Hi Tibor-
>> >
>> > I have enabled writing to the Event Log and notification to my e-mail
>> > but
>> > the error message is extremely vague:
>> >
>> > Event Type: Warning
>> > Event Source: SQLSERVERAGENT
>> > Event Category: Job Engine
>> > Event ID: 208
>> > Date: 4/20/2005
>> > Time: 10:13:13 AM
>> > User: N/A
>> > Computer: XXXXXXXXX
>> > Description:
>> > SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
>> > 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
>> > Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job
>> > failed.
>> > The Job was invoked by User XXX\ADMINISTRATOR. The last step to run
>> > was step
>> > 1 (Step 1).
>> >
>> > For more information, see Help and Support Center at
>> > http://go.microsoft.com/fwlink/events.asp.
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> I suggest you specify a report file for the Maint plan and check for
>> >> specific error messages in
>> >> that
>> >> report file.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
>> >> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
>> >> > Hi All-
>> >> >
>> >> > I have a websense log database that the Optimization and Integrity
>> >> > check
>> >> > jobs fail on. My problem is I cannot determine WHY exactly these
>> >> > jobs have
>> >> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands
>> >> > nothing
>> >> > appears to be a problem. I even tried running the optimization and
>> >> > integrity
>> >> > checks while the database is in single user mode to no avail. How
>> >> > can I A.
>> >> > determine what the problem is and B. correct it?
>> >> >
>> >> > Thank You for your help in advance!
>> >> >
>> >> > --GREENTHUMB--
>> >>
>> >>
>> >>
>>
I have a websense log database that the Optimization and Integrity check
jobs fail on. My problem is I cannot determine WHY exactly these jobs have
failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
appears to be a problem. I even tried running the optimization and integrity
checks while the database is in single user mode to no avail. How can I A.
determine what the problem is and B. correct it?
Thank You for your help in advance!
--GREENTHUMB--I suggest you specify a report file for the Maint plan and check for specific error messages in that
report file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> Hi All-
> I have a websense log database that the Optimization and Integrity check
> jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> appears to be a problem. I even tried running the optimization and integrity
> checks while the database is in single user mode to no avail. How can I A.
> determine what the problem is and B. correct it?
> Thank You for your help in advance!
> --GREENTHUMB--|||Hi Tibor-
I have enabled writing to the Event Log and notification to my e-mail but
the error message is extremely vague:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 4/20/2005
Time: 10:13:13 AM
User: N/A
Computer: XXXXXXXXX
Description:
SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
1 (Step 1).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"Tibor Karaszi" wrote:
> I suggest you specify a report file for the Maint plan and check for specific error messages in that
> report file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> > Hi All-
> >
> > I have a websense log database that the Optimization and Integrity check
> > jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> > appears to be a problem. I even tried running the optimization and integrity
> > checks while the database is in single user mode to no avail. How can I A.
> > determine what the problem is and B. correct it?
> >
> > Thank You for your help in advance!
> >
> > --GREENTHUMB--
>
>|||The vagueness of that message is exactly why I suggested to specify in the maint plan to create a
report file. In there you will find the error messages from SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
> Hi Tibor-
> I have enabled writing to the Event Log and notification to my e-mail but
> the error message is extremely vague:
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 4/20/2005
> Time: 10:13:13 AM
> User: N/A
> Computer: XXXXXXXXX
> Description:
> SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
> 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
> Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
> The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
> 1 (Step 1).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> "Tibor Karaszi" wrote:
>> I suggest you specify a report file for the Maint plan and check for specific error messages in
>> that
>> report file.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
>> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
>> > Hi All-
>> >
>> > I have a websense log database that the Optimization and Integrity check
>> > jobs fail on. My problem is I cannot determine WHY exactly these jobs have
>> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
>> > appears to be a problem. I even tried running the optimization and integrity
>> > checks while the database is in single user mode to no avail. How can I A.
>> > determine what the problem is and B. correct it?
>> >
>> > Thank You for your help in advance!
>> >
>> > --GREENTHUMB--
>>|||Hi Tibor-
Okay - I enabled the reports and the error given is "database is already
open and can only have one user at a time". However, I checked Single User
Mode *AND* even detached and re-attached and set to Single User to no avail.
I also checked Process info. but that database was not being accessed. Any
ideas?
Thank You!!!
--GREENTHUMB--
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'ORCRASV005' as 'GWN\services' (trusted)
Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
6:35:03 PM
[1] Database wslogdb55: Check Data and Index Linkage...
[Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is already
open and can only have one user at a time.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb55' is
already open and can only have one user at a time.
** Execution Time: 0 hrs, 0 mins, 4 secs **
End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005 6:35:07
PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
"Tibor Karaszi" wrote:
> The vagueness of that message is exactly why I suggested to specify in the maint plan to create a
> report file. In there you will find the error messages from SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
> > Hi Tibor-
> >
> > I have enabled writing to the Event Log and notification to my e-mail but
> > the error message is extremely vague:
> >
> > Event Type: Warning
> > Event Source: SQLSERVERAGENT
> > Event Category: Job Engine
> > Event ID: 208
> > Date: 4/20/2005
> > Time: 10:13:13 AM
> > User: N/A
> > Computer: XXXXXXXXX
> > Description:
> > SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
> > 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
> > Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
> > The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
> > 1 (Step 1).
> >
> > For more information, see Help and Support Center at
> > http://go.microsoft.com/fwlink/events.asp.
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> I suggest you specify a report file for the Maint plan and check for specific error messages in
> >> that
> >> report file.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> >> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> >> > Hi All-
> >> >
> >> > I have a websense log database that the Optimization and Integrity check
> >> > jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> >> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> >> > appears to be a problem. I even tried running the optimization and integrity
> >> > checks while the database is in single user mode to no avail. How can I A.
> >> > determine what the problem is and B. correct it?
> >> >
> >> > Thank You for your help in advance!
> >> >
> >> > --GREENTHUMB--
> >>
> >>
> >>
>
>|||You need to uncheck the checkbox in the maintenance plan that says to
"Repair minor problems" and it should work fine. When you have that checked
it tries to put the db in single user mode and if it can't it errors. You
really don't want it repairing things on it's own anyway.
--
Andrew J. Kelly SQL MVP
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:432B45E0-DA60-455B-AA32-84EC8FCC3700@.microsoft.com...
> Hi Tibor-
> Okay - I enabled the reports and the error given is "database is already
> open and can only have one user at a time". However, I checked Single
> User
> Mode *AND* even detached and re-attached and set to Single User to no
> avail.
> I also checked Process info. but that database was not being accessed.
> Any
> ideas?
> Thank You!!!
> --GREENTHUMB--
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'ORCRASV005' as 'GWN\services' (trusted)
> Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:03 PM
> [1] Database wslogdb55: Check Data and Index Linkage...
> [Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is already
> open and can only have one user at a time.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb55' is
> already open and can only have one user at a time.
> ** Execution Time: 0 hrs, 0 mins, 4 secs **
> End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:07
> PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> "Tibor Karaszi" wrote:
>> The vagueness of that message is exactly why I suggested to specify in
>> the maint plan to create a
>> report file. In there you will find the error messages from SQL Server.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
>> news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
>> > Hi Tibor-
>> >
>> > I have enabled writing to the Event Log and notification to my e-mail
>> > but
>> > the error message is extremely vague:
>> >
>> > Event Type: Warning
>> > Event Source: SQLSERVERAGENT
>> > Event Category: Job Engine
>> > Event ID: 208
>> > Date: 4/20/2005
>> > Time: 10:13:13 AM
>> > User: N/A
>> > Computer: XXXXXXXXX
>> > Description:
>> > SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
>> > 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
>> > Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job
>> > failed.
>> > The Job was invoked by User XXX\ADMINISTRATOR. The last step to run
>> > was step
>> > 1 (Step 1).
>> >
>> > For more information, see Help and Support Center at
>> > http://go.microsoft.com/fwlink/events.asp.
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> I suggest you specify a report file for the Maint plan and check for
>> >> specific error messages in
>> >> that
>> >> report file.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
>> >> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
>> >> > Hi All-
>> >> >
>> >> > I have a websense log database that the Optimization and Integrity
>> >> > check
>> >> > jobs fail on. My problem is I cannot determine WHY exactly these
>> >> > jobs have
>> >> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands
>> >> > nothing
>> >> > appears to be a problem. I even tried running the optimization and
>> >> > integrity
>> >> > checks while the database is in single user mode to no avail. How
>> >> > can I A.
>> >> > determine what the problem is and B. correct it?
>> >> >
>> >> > Thank You for your help in advance!
>> >> >
>> >> > --GREENTHUMB--
>> >>
>> >>
>> >>
>>
Integrity and Optimization failures
Hi All-
I have a websense log database that the Optimization and Integrity check
jobs fail on. My problem is I cannot determine WHY exactly these jobs have
failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
appears to be a problem. I even tried running the optimization and integrity
checks while the database is in single user mode to no avail. How can I A.
determine what the problem is and B. correct it?
Thank You for your help in advance!
--GREENTHUMB--
I suggest you specify a report file for the Maint plan and check for specific error messages in that
report file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> Hi All-
> I have a websense log database that the Optimization and Integrity check
> jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> appears to be a problem. I even tried running the optimization and integrity
> checks while the database is in single user mode to no avail. How can I A.
> determine what the problem is and B. correct it?
> Thank You for your help in advance!
> --GREENTHUMB--
|||Hi Tibor-
I have enabled writing to the Event Log and notification to my e-mail but
the error message is extremely vague:
Event Type:Warning
Event Source:SQLSERVERAGENT
Event Category:Job Engine
Event ID:208
Date:4/20/2005
Time:10:13:13 AM
User:N/A
Computer:XXXXXXXXX
Description:
SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
1 (Step 1).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"Tibor Karaszi" wrote:
> I suggest you specify a report file for the Maint plan and check for specific error messages in that
> report file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
>
>
|||The vagueness of that message is exactly why I suggested to specify in the maint plan to create a
report file. In there you will find the error messages from SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...[vbcol=seagreen]
> Hi Tibor-
> I have enabled writing to the Event Log and notification to my e-mail but
> the error message is extremely vague:
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 4/20/2005
> Time: 10:13:13 AM
> User: N/A
> Computer: XXXXXXXXX
> Description:
> SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
> 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
> Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
> The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
> 1 (Step 1).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> "Tibor Karaszi" wrote:
|||Hi Tibor-
Okay - I enabled the reports and the error given is "database is already
open and can only have one user at a time". However, I checked Single User
Mode *AND* even detached and re-attached and set to Single User to no avail.
I also checked Process info. but that database was not being accessed. Any
ideas?
Thank You!!!
--GREENTHUMB--
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'ORCRASV005' as 'GWN\services' (trusted)
Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
6:35:03 PM
[1] Database wslogdb55: Check Data and Index Linkage...
[Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is already
open and can only have one user at a time.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb55' is
already open and can only have one user at a time.
** Execution Time: 0 hrs, 0 mins, 4 secs **
End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005 6:35:07
PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
"Tibor Karaszi" wrote:
> The vagueness of that message is exactly why I suggested to specify in the maint plan to create a
> report file. In there you will find the error messages from SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
>
>
|||You need to uncheck the checkbox in the maintenance plan that says to
"Repair minor problems" and it should work fine. When you have that checked
it tries to put the db in single user mode and if it can't it errors. You
really don't want it repairing things on it's own anyway.
Andrew J. Kelly SQL MVP
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:432B45E0-DA60-455B-AA32-84EC8FCC3700@.microsoft.com...[vbcol=seagreen]
> Hi Tibor-
> Okay - I enabled the reports and the error given is "database is already
> open and can only have one user at a time". However, I checked Single
> User
> Mode *AND* even detached and re-attached and set to Single User to no
> avail.
> I also checked Process info. but that database was not being accessed.
> Any
> ideas?
> Thank You!!!
> --GREENTHUMB--
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'ORCRASV005' as 'GWN\services' (trusted)
> Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:03 PM
> [1] Database wslogdb55: Check Data and Index Linkage...
> [Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is already
> open and can only have one user at a time.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb55' is
> already open and can only have one user at a time.
> ** Execution Time: 0 hrs, 0 mins, 4 secs **
> End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:07
> PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> "Tibor Karaszi" wrote:
|||Since this job is checking database integrity, is this always a good
practice?
I have a websense log database that the Optimization and Integrity check
jobs fail on. My problem is I cannot determine WHY exactly these jobs have
failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
appears to be a problem. I even tried running the optimization and integrity
checks while the database is in single user mode to no avail. How can I A.
determine what the problem is and B. correct it?
Thank You for your help in advance!
--GREENTHUMB--
I suggest you specify a report file for the Maint plan and check for specific error messages in that
report file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> Hi All-
> I have a websense log database that the Optimization and Integrity check
> jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> appears to be a problem. I even tried running the optimization and integrity
> checks while the database is in single user mode to no avail. How can I A.
> determine what the problem is and B. correct it?
> Thank You for your help in advance!
> --GREENTHUMB--
|||Hi Tibor-
I have enabled writing to the Event Log and notification to my e-mail but
the error message is extremely vague:
Event Type:Warning
Event Source:SQLSERVERAGENT
Event Category:Job Engine
Event ID:208
Date:4/20/2005
Time:10:13:13 AM
User:N/A
Computer:XXXXXXXXX
Description:
SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
1 (Step 1).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"Tibor Karaszi" wrote:
> I suggest you specify a report file for the Maint plan and check for specific error messages in that
> report file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
>
>
|||The vagueness of that message is exactly why I suggested to specify in the maint plan to create a
report file. In there you will find the error messages from SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...[vbcol=seagreen]
> Hi Tibor-
> I have enabled writing to the Event Log and notification to my e-mail but
> the error message is extremely vague:
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 4/20/2005
> Time: 10:13:13 AM
> User: N/A
> Computer: XXXXXXXXX
> Description:
> SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
> 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
> Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
> The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
> 1 (Step 1).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> "Tibor Karaszi" wrote:
|||Hi Tibor-
Okay - I enabled the reports and the error given is "database is already
open and can only have one user at a time". However, I checked Single User
Mode *AND* even detached and re-attached and set to Single User to no avail.
I also checked Process info. but that database was not being accessed. Any
ideas?
Thank You!!!
--GREENTHUMB--
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'ORCRASV005' as 'GWN\services' (trusted)
Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
6:35:03 PM
[1] Database wslogdb55: Check Data and Index Linkage...
[Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is already
open and can only have one user at a time.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb55' is
already open and can only have one user at a time.
** Execution Time: 0 hrs, 0 mins, 4 secs **
End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005 6:35:07
PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
"Tibor Karaszi" wrote:
> The vagueness of that message is exactly why I suggested to specify in the maint plan to create a
> report file. In there you will find the error messages from SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
>
>
|||You need to uncheck the checkbox in the maintenance plan that says to
"Repair minor problems" and it should work fine. When you have that checked
it tries to put the db in single user mode and if it can't it errors. You
really don't want it repairing things on it's own anyway.
Andrew J. Kelly SQL MVP
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:432B45E0-DA60-455B-AA32-84EC8FCC3700@.microsoft.com...[vbcol=seagreen]
> Hi Tibor-
> Okay - I enabled the reports and the error given is "database is already
> open and can only have one user at a time". However, I checked Single
> User
> Mode *AND* even detached and re-attached and set to Single User to no
> avail.
> I also checked Process info. but that database was not being accessed.
> Any
> ideas?
> Thank You!!!
> --GREENTHUMB--
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'ORCRASV005' as 'GWN\services' (trusted)
> Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:03 PM
> [1] Database wslogdb55: Check Data and Index Linkage...
> [Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is already
> open and can only have one user at a time.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb55' is
> already open and can only have one user at a time.
> ** Execution Time: 0 hrs, 0 mins, 4 secs **
> End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:07
> PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> "Tibor Karaszi" wrote:
|||Since this job is checking database integrity, is this always a good
practice?
Subscribe to:
Posts (Atom)