Just inherited a couple os SQL V7 servers and am reviewing the backups they
have been doing. New to SQL server.
In Enterprise Manager in the plan window I see two intregrity options
1) check database integrity (which is not checked)
2) verify the intergrity of the backup upon completion (checked)
What is number 2 doing?
If #1 is not checked, it seems to me their is no DBCC being run. So far I
cannot get their ops dept to send me the job logs for these backups so at
this point want to make sure from what I can see in Enterprise Manager that
they are running consistancy checks.
Thanks
Mike Lackey
Database Adminstration
Sybase/Oracle and enthusiastically trying to learn MSSQL
If #1 is not checked and there are no other jobs doing this that means there
are no DBCC CHECKDB's being run.
#2 refers to issuing a Verify against the backup after it completes and does
not pertain to DBCC's.
Andrew J. Kelly SQL MVP
"Mike Lackey" <MikeLackey@.discussions.microsoft.com> wrote in message
news:15060A70-AAE2-43D4-86C5-CCC0B08483A8@.microsoft.com...
> Just inherited a couple os SQL V7 servers and am reviewing the backups
they
> have been doing. New to SQL server.
> In Enterprise Manager in the plan window I see two intregrity options
> 1) check database integrity (which is not checked)
> 2) verify the intergrity of the backup upon completion (checked)
> What is number 2 doing?
> If #1 is not checked, it seems to me their is no DBCC being run. So far I
> cannot get their ops dept to send me the job logs for these backups so at
> this point want to make sure from what I can see in Enterprise Manager
that
> they are running consistancy checks.
> Thanks
> --
> Mike Lackey
> Database Adminstration
> Sybase/Oracle and enthusiastically trying to learn MSSQL
Showing posts with label checks. Show all posts
Showing posts with label checks. Show all posts
Saturday, February 25, 2012
Maintenance Plans and Integrity checks
Just inherited a couple os SQL V7 servers and am reviewing the backups they
have been doing. New to SQL server.
In Enterprise Manager in the plan window I see two intregrity options
1) check database integrity (which is not checked)
2) verify the intergrity of the backup upon completion (checked)
What is number 2 doing?
If #1 is not checked, it seems to me their is no DBCC being run. So far I
cannot get their ops dept to send me the job logs for these backups so at
this point want to make sure from what I can see in Enterprise Manager that
they are running consistancy checks.
Thanks
--
Mike Lackey
Database Adminstration
Sybase/Oracle and enthusiastically trying to learn MSSQLIf #1 is not checked and there are no other jobs doing this that means there
are no DBCC CHECKDB's being run.
#2 refers to issuing a Verify against the backup after it completes and does
not pertain to DBCC's.
--
Andrew J. Kelly SQL MVP
"Mike Lackey" <MikeLackey@.discussions.microsoft.com> wrote in message
news:15060A70-AAE2-43D4-86C5-CCC0B08483A8@.microsoft.com...
> Just inherited a couple os SQL V7 servers and am reviewing the backups
they
> have been doing. New to SQL server.
> In Enterprise Manager in the plan window I see two intregrity options
> 1) check database integrity (which is not checked)
> 2) verify the intergrity of the backup upon completion (checked)
> What is number 2 doing?
> If #1 is not checked, it seems to me their is no DBCC being run. So far I
> cannot get their ops dept to send me the job logs for these backups so at
> this point want to make sure from what I can see in Enterprise Manager
that
> they are running consistancy checks.
> Thanks
> --
> Mike Lackey
> Database Adminstration
> Sybase/Oracle and enthusiastically trying to learn MSSQL
have been doing. New to SQL server.
In Enterprise Manager in the plan window I see two intregrity options
1) check database integrity (which is not checked)
2) verify the intergrity of the backup upon completion (checked)
What is number 2 doing?
If #1 is not checked, it seems to me their is no DBCC being run. So far I
cannot get their ops dept to send me the job logs for these backups so at
this point want to make sure from what I can see in Enterprise Manager that
they are running consistancy checks.
Thanks
--
Mike Lackey
Database Adminstration
Sybase/Oracle and enthusiastically trying to learn MSSQLIf #1 is not checked and there are no other jobs doing this that means there
are no DBCC CHECKDB's being run.
#2 refers to issuing a Verify against the backup after it completes and does
not pertain to DBCC's.
--
Andrew J. Kelly SQL MVP
"Mike Lackey" <MikeLackey@.discussions.microsoft.com> wrote in message
news:15060A70-AAE2-43D4-86C5-CCC0B08483A8@.microsoft.com...
> Just inherited a couple os SQL V7 servers and am reviewing the backups
they
> have been doing. New to SQL server.
> In Enterprise Manager in the plan window I see two intregrity options
> 1) check database integrity (which is not checked)
> 2) verify the intergrity of the backup upon completion (checked)
> What is number 2 doing?
> If #1 is not checked, it seems to me their is no DBCC being run. So far I
> cannot get their ops dept to send me the job logs for these backups so at
> this point want to make sure from what I can see in Enterprise Manager
that
> they are running consistancy checks.
> Thanks
> --
> Mike Lackey
> Database Adminstration
> Sybase/Oracle and enthusiastically trying to learn MSSQL
Maintenance Plans
I created a SQL Server Maintenance Plan that performs sql
backups, optimizations and integrity checks through a
maintenance plan.
The backup portion of the maintenance plan works okay.
But the optimization and integrity checks fail with the
following errors:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
because the following SET options have incorrect
settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
We are running SQL 2000 Standard Edition SP3.
I saw the Microsoft Knowledge Base Article - 301292 which
seems to be the problem. I tried setting the sp_options
mentioned in the article at the database level but the
problem still occurred. I really want to use a generic
maintenance plan, I don't want to have to write jobs for
each database I need to perform optimization or integrity
checks on.
As a side note the database that is reporting the errors
is part of a sharepoint install.
Any help would be great.
Thanks.
Gary,
We ran into this also, but the Maintenance Plan will not issue the proper
SET as the note describes. The only way that I know to do it is to go ahead
and write your own script.
Sorry,
Russell Fields
"Gary Murphy" <anonymous@.discussions.microsoft.com> wrote in message
news:ec0c01c43d0e$6512bda0$a101280a@.phx.gbl...
> I created a SQL Server Maintenance Plan that performs sql
> backups, optimizations and integrity checks through a
> maintenance plan.
> The backup portion of the maintenance plan works okay.
> But the optimization and integrity checks fail with the
> following errors:
> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
> because the following SET options have incorrect
> settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> We are running SQL 2000 Standard Edition SP3.
> I saw the Microsoft Knowledge Base Article - 301292 which
> seems to be the problem. I tried setting the sp_options
> mentioned in the article at the database level but the
> problem still occurred. I really want to use a generic
> maintenance plan, I don't want to have to write jobs for
> each database I need to perform optimization or integrity
> checks on.
> As a side note the database that is reporting the errors
> is part of a sharepoint install.
> Any help would be great.
> Thanks.
backups, optimizations and integrity checks through a
maintenance plan.
The backup portion of the maintenance plan works okay.
But the optimization and integrity checks fail with the
following errors:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
because the following SET options have incorrect
settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
We are running SQL 2000 Standard Edition SP3.
I saw the Microsoft Knowledge Base Article - 301292 which
seems to be the problem. I tried setting the sp_options
mentioned in the article at the database level but the
problem still occurred. I really want to use a generic
maintenance plan, I don't want to have to write jobs for
each database I need to perform optimization or integrity
checks on.
As a side note the database that is reporting the errors
is part of a sharepoint install.
Any help would be great.
Thanks.
Gary,
We ran into this also, but the Maintenance Plan will not issue the proper
SET as the note describes. The only way that I know to do it is to go ahead
and write your own script.
Sorry,
Russell Fields
"Gary Murphy" <anonymous@.discussions.microsoft.com> wrote in message
news:ec0c01c43d0e$6512bda0$a101280a@.phx.gbl...
> I created a SQL Server Maintenance Plan that performs sql
> backups, optimizations and integrity checks through a
> maintenance plan.
> The backup portion of the maintenance plan works okay.
> But the optimization and integrity checks fail with the
> following errors:
> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
> because the following SET options have incorrect
> settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> We are running SQL 2000 Standard Edition SP3.
> I saw the Microsoft Knowledge Base Article - 301292 which
> seems to be the problem. I tried setting the sp_options
> mentioned in the article at the database level but the
> problem still occurred. I really want to use a generic
> maintenance plan, I don't want to have to write jobs for
> each database I need to perform optimization or integrity
> checks on.
> As a side note the database that is reporting the errors
> is part of a sharepoint install.
> Any help would be great.
> Thanks.
Maintenance Plans
I created a SQL Server Maintenance Plan that performs sql
backups, optimizations and integrity checks through a
maintenance plan.
The backup portion of the maintenance plan works okay.
But the optimization and integrity checks fail with the
following errors:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
because the following SET options have incorrect
settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
We are running SQL 2000 Standard Edition SP3.
I saw the Microsoft Knowledge Base Article - 301292 which
seems to be the problem. I tried setting the sp_options
mentioned in the article at the database level but the
problem still occurred. I really want to use a generic
maintenance plan, I don't want to have to write jobs for
each database I need to perform optimization or integrity
checks on.
As a side note the database that is reporting the errors
is part of a sharepoint install.
Any help would be great.
Thanks.Gary,
We ran into this also, but the Maintenance Plan will not issue the proper
SET as the note describes. The only way that I know to do it is to go ahead
and write your own script.
Sorry,
Russell Fields
"Gary Murphy" <anonymous@.discussions.microsoft.com> wrote in message
news:ec0c01c43d0e$6512bda0$a101280a@.phx.gbl...
> I created a SQL Server Maintenance Plan that performs sql
> backups, optimizations and integrity checks through a
> maintenance plan.
> The backup portion of the maintenance plan works okay.
> But the optimization and integrity checks fail with the
> following errors:
> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
> because the following SET options have incorrect
> settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> We are running SQL 2000 Standard Edition SP3.
> I saw the Microsoft Knowledge Base Article - 301292 which
> seems to be the problem. I tried setting the sp_options
> mentioned in the article at the database level but the
> problem still occurred. I really want to use a generic
> maintenance plan, I don't want to have to write jobs for
> each database I need to perform optimization or integrity
> checks on.
> As a side note the database that is reporting the errors
> is part of a sharepoint install.
> Any help would be great.
> Thanks.
backups, optimizations and integrity checks through a
maintenance plan.
The backup portion of the maintenance plan works okay.
But the optimization and integrity checks fail with the
following errors:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
because the following SET options have incorrect
settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
We are running SQL 2000 Standard Edition SP3.
I saw the Microsoft Knowledge Base Article - 301292 which
seems to be the problem. I tried setting the sp_options
mentioned in the article at the database level but the
problem still occurred. I really want to use a generic
maintenance plan, I don't want to have to write jobs for
each database I need to perform optimization or integrity
checks on.
As a side note the database that is reporting the errors
is part of a sharepoint install.
Any help would be great.
Thanks.Gary,
We ran into this also, but the Maintenance Plan will not issue the proper
SET as the note describes. The only way that I know to do it is to go ahead
and write your own script.
Sorry,
Russell Fields
"Gary Murphy" <anonymous@.discussions.microsoft.com> wrote in message
news:ec0c01c43d0e$6512bda0$a101280a@.phx.gbl...
> I created a SQL Server Maintenance Plan that performs sql
> backups, optimizations and integrity checks through a
> maintenance plan.
> The backup portion of the maintenance plan works okay.
> But the optimization and integrity checks fail with the
> following errors:
> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
> because the following SET options have incorrect
> settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> We are running SQL 2000 Standard Edition SP3.
> I saw the Microsoft Knowledge Base Article - 301292 which
> seems to be the problem. I tried setting the sp_options
> mentioned in the article at the database level but the
> problem still occurred. I really want to use a generic
> maintenance plan, I don't want to have to write jobs for
> each database I need to perform optimization or integrity
> checks on.
> As a side note the database that is reporting the errors
> is part of a sharepoint install.
> Any help would be great.
> Thanks.
Maintenance Plans
I created a SQL Server Maintenance Plan that performs sql
backups, optimizations and integrity checks through a
maintenance plan.
The backup portion of the maintenance plan works okay.
But the optimization and integrity checks fail with the
following errors:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
because the following SET options have incorrect
settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
We are running SQL 2000 Standard Edition SP3.
I saw the Microsoft Knowledge Base Article - 301292 which
seems to be the problem. I tried setting the sp_options
mentioned in the article at the database level but the
problem still occurred. I really want to use a generic
maintenance plan, I don't want to have to write jobs for
each database I need to perform optimization or integrity
checks on.
As a side note the database that is reporting the errors
is part of a sharepoint install.
Any help would be great.
Thanks.Gary,
We ran into this also, but the Maintenance Plan will not issue the proper
SET as the note describes. The only way that I know to do it is to go ahead
and write your own script.
Sorry,
Russell Fields
"Gary Murphy" <anonymous@.discussions.microsoft.com> wrote in message
news:ec0c01c43d0e$6512bda0$a101280a@.phx.gbl...
> I created a SQL Server Maintenance Plan that performs sql
> backups, optimizations and integrity checks through a
> maintenance plan.
> The backup portion of the maintenance plan works okay.
> But the optimization and integrity checks fail with the
> following errors:
> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
> because the following SET options have incorrect
> settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> We are running SQL 2000 Standard Edition SP3.
> I saw the Microsoft Knowledge Base Article - 301292 which
> seems to be the problem. I tried setting the sp_options
> mentioned in the article at the database level but the
> problem still occurred. I really want to use a generic
> maintenance plan, I don't want to have to write jobs for
> each database I need to perform optimization or integrity
> checks on.
> As a side note the database that is reporting the errors
> is part of a sharepoint install.
> Any help would be great.
> Thanks.
backups, optimizations and integrity checks through a
maintenance plan.
The backup portion of the maintenance plan works okay.
But the optimization and integrity checks fail with the
following errors:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
because the following SET options have incorrect
settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
We are running SQL 2000 Standard Edition SP3.
I saw the Microsoft Knowledge Base Article - 301292 which
seems to be the problem. I tried setting the sp_options
mentioned in the article at the database level but the
problem still occurred. I really want to use a generic
maintenance plan, I don't want to have to write jobs for
each database I need to perform optimization or integrity
checks on.
As a side note the database that is reporting the errors
is part of a sharepoint install.
Any help would be great.
Thanks.Gary,
We ran into this also, but the Maintenance Plan will not issue the proper
SET as the note describes. The only way that I know to do it is to go ahead
and write your own script.
Sorry,
Russell Fields
"Gary Murphy" <anonymous@.discussions.microsoft.com> wrote in message
news:ec0c01c43d0e$6512bda0$a101280a@.phx.gbl...
> I created a SQL Server Maintenance Plan that performs sql
> backups, optimizations and integrity checks through a
> maintenance plan.
> The backup portion of the maintenance plan works okay.
> But the optimization and integrity checks fail with the
> following errors:
> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
> because the following SET options have incorrect
> settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> We are running SQL 2000 Standard Edition SP3.
> I saw the Microsoft Knowledge Base Article - 301292 which
> seems to be the problem. I tried setting the sp_options
> mentioned in the article at the database level but the
> problem still occurred. I really want to use a generic
> maintenance plan, I don't want to have to write jobs for
> each database I need to perform optimization or integrity
> checks on.
> As a side note the database that is reporting the errors
> is part of a sharepoint install.
> Any help would be great.
> Thanks.
Subscribe to:
Posts (Atom)