<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
DBCC REINDEX - Offline?
DBCC REINDEX - Offline?
Rate Topic
Display Mode
Topic Options
Author
Message
Matt-566349
Matt-566349
Posted Friday, May 09, 2008 2:59 PM
Forum Newbie
Group: General Forum Members
Last Login: Friday, July 08, 2011 2:42 PM
Points: 9,
Visits: 186
I've read that DBCC REINDEX is an offline operation, because while the REINDEX is in progress, the underlying table is locked.
I would like to set up a DBCC REINDEX script to run at off-peak times. I would like to have the application still available to users while this is running. (I know that performance will be hampered, but that's acceptable as a very small number of users (if any) will be using the system during this period). I would like to make this an automated job, and don't want to have to log in to manually kill the application services before running the script.
Do I risk corrupting the database if I run this while the database is online? Or is it just recommended to be run offline because the table of the index being updated is locked?
Post #498246
matt stockham
matt stockham
Posted Friday, May 09, 2008 5:13 PM
Right there with Babe
Group: General Forum Members
Last Login: Thursday, June 06, 2013 9:36 AM
Points: 750,
Visits: 2,946
If you are using the Enterprise edition of SQL2005, you can do online rebuilds with
ALTER INDEX [index] ON [table] REBUILD WITH (ONLINE = ON)
There is no danger of corruption using this process.
Post #498276
Ola Hallengren
Ola Hallengren
Posted Saturday, May 10, 2008 3:26 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: 2 days ago @ 11:37 AM
Points: 168,
Visits: 1,769
Not all indexes can be rebuilt online. Clustered indexes on tables with LOB columns cannot be rebuilt online. Non clustered indexes with LOB columns in the index definition cannot be rebuilt online either.
http://msdn.microsoft.com/en-us/library/ms188388.aspx
Ola Hallengren
http://ola.hallengren.com
Post #498338
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
