Maintenance plans: online rebuilding of indexes...

I'm using SQL Server 2005 SP1 Standard.

On the Rebuild Index Task there is a checkbox at the bottom that says 'Keep index online while reindexing'.

Great I thought, I'll check that.

Later, when I tested the job, I got this error:

'Online index operations can only be performed in Enterprise edition of SQL Server.'

Why have that checkbox available to check, if I'm running a version that doesn't allow it? Where's the bug?

Thanks

Ed

I've entered a bug in our tracking database.

Thanks,

Mark

Maintenance Plans - Master, MSDB, etc.

I currently have a maintenance plan setup to do typical
optimizations/reindexing of our user databases. Is it a good practice to do
this on the Master database or the MSDB database? The MSDB seems like the
better candidate of the two since we work with DTS quite a bit. BUT, by a
"bit" I mean we have a MSDB database around 200 MB.
Thanks in advance.
MarkOptimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>|||Oh, but do make sure you do the integrity checks!
Anthony Thomas
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:efErdhAAFHA.3616@.TK2MSFTNGP11.phx.gbl...
Optimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>

Maintenance Plans - Master, MSDB, etc.

I currently have a maintenance plan setup to do typical
optimizations/reindexing of our user databases. Is it a good practice to do
this on the Master database or the MSDB database? The MSDB seems like the
better candidate of the two since we work with DTS quite a bit. BUT, by a
"bit" I mean we have a MSDB database around 200 MB.
Thanks in advance.
Mark
Optimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>
|||Oh, but do make sure you do the integrity checks!
Anthony Thomas

"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:efErdhAAFHA.3616@.TK2MSFTNGP11.phx.gbl...
Optimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>

Maintenance Plans - Master, MSDB, etc.

I currently have a maintenance plan setup to do typical
optimizations/reindexing of our user databases. Is it a good practice to do
this on the Master database or the MSDB database? The MSDB seems like the
better candidate of the two since we work with DTS quite a bit. BUT, by a
"bit" I mean we have a MSDB database around 200 MB.
Thanks in advance.
MarkOptimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
--
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>|||Oh, but do make sure you do the integrity checks!
Anthony Thomas
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:efErdhAAFHA.3616@.TK2MSFTNGP11.phx.gbl...
Optimizations do not really apply to the system dbs with the MP since it
uses DBCC DBREINDEX and that is not supported on system tables.
--
Andrew J. Kelly SQL MVP
"Mark" <Mark@.nowhere.com> wrote in message
news:e1kwcG$$EHA.3416@.TK2MSFTNGP09.phx.gbl...
>I currently have a maintenance plan setup to do typical
> optimizations/reindexing of our user databases. Is it a good practice to
> do
> this on the Master database or the MSDB database? The MSDB seems like the
> better candidate of the two since we work with DTS quite a bit. BUT, by a
> "bit" I mean we have a MSDB database around 200 MB.
> Thanks in advance.
> Mark
>

Maintenance plan, reindexing

In the Enterprise Manager of SQL Server 2000 I have set up a maintenance plan which rebuilds my indexes. I've stuided the documentation, and from what I've learned what happens behind the curtain is that several DBCC REINDEX commands are being issued.
Question:
If I have 20 tables and 40 indexes: Will SQL Server do the maintance plan in 1 single transaction, or will it divide the it up to eg. 20 or 40 transactions?

-hIf your SQL Server Agent is installed with a Service Account,create Jobs to run the Reindex DBCC on the large tables and usethe Maintaince Plans for minor problems. It is also a good ideato document the maintaince plans. I think if the reindex includesrepair SQL Server must be in single user mode. One of the bestbooks on SQL Server indexes is by Ken England he quantifies theIAM(Index Allocation Mapping) pages. Hope this helps.
Kind regards,
Gift Peddie