Re: reindex maintenance plan
From: pdxJaxon (GregoryAJackson_at_Hotmail.com)
Date: 02/07/05
- Next message: Tomasz Borawski: "RE: creating jobs in EM via terminal services"
- Previous message: Brett Wilson: "Re: MS Access can't find Recordsource object"
- In reply to: itchicago: "reindex maintenance plan"
- Next in thread: Paul S Randal [MS]: "Re: reindex maintenance plan"
- Reply: Paul S Randal [MS]: "Re: reindex maintenance plan"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 7 Feb 2005 08:08:42 -0800
not exactly sure what you mean by "Halts Entire System". However, the
maintenance plan wizard uses DBCC DBReindex for index maintenance. DBReindex
places exclusive table locks on tables being defragged.
You may want to consider using your own custom index maintenance routines
and implementing index maintenance via "DBCC IndexDefrag" instead.
cheers
Greg Jackson
Portland, OR
- Next message: Tomasz Borawski: "RE: creating jobs in EM via terminal services"
- Previous message: Brett Wilson: "Re: MS Access can't find Recordsource object"
- In reply to: itchicago: "reindex maintenance plan"
- Next in thread: Paul S Randal [MS]: "Re: reindex maintenance plan"
- Reply: Paul S Randal [MS]: "Re: reindex maintenance plan"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
