You still didn't answer Hari's question as to what version. If you are in
SQL2005 you have the option to rebuild the index online or offline. You can
defrag the index online in either version.
--
Andrew J. Kelly SQL MVP
[quoted text, click to view] "Don" <Don@discussions.microsoft.com> wrote in message
news:1D534C35-708C-4378-89D3-7E4B22911260@microsoft.com...
> Deframenting the index
>
> Thanks
>
> "Hari Prasad" wrote:
>
>> Hello,
>>
>> Can you specify the maintenance tasks you plan to perform and do mention
>> the
>> SLQ Server version as well.
>>
>> Thanks
>> Hari
>>
>> "Don" <Don@discussions.microsoft.com> wrote in message
>> news:9EAB2423-4714-46B4-95EB-18035A48D742@microsoft.com...
>> >I need to perform some routine database maintenance tasks.
>> >
>> > I know these tasks can be performed by the use of the maintenance
>> > plans.
>> > My question is whether the databse has to be set offline (i.e. whether
>> > the
>> > clients have to stop using the database when i'm doing the maintenance)
>> >
>>
>>
>>