all groups > sql server programming > april 2007 >
You're in the

sql server programming

group:

database maintenance


database maintenance Don
4/22/2007 8:40:03 PM
sql server programming:
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)
Re: database maintenance Andrew J. Kelly
4/23/2007 12:00:00 AM
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]

Re: database maintenance Hari Prasad
4/23/2007 12:19:32 AM
Hello,

Can you specify the maintenance tasks you plan to perform and do mention the
SLQ Server version as well.

Thanks
Hari

[quoted text, click to view]

Re: database maintenance Don
4/23/2007 12:40:02 AM
Deframenting the index

Thanks

[quoted text, click to view]
Re: database maintenance nj
4/23/2007 1:18:14 AM

Running DBCC INDEXDEFRAG not require database to bring offline. This
is online operation.

Running DBCC DBREINDEX locks table so should be done during
maintenance window .

NJ

[quoted text, click to view]

AddThis Social Bookmark Button