Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-06-20 : 17:45:08
|
| will it happen any thing wrong if i suddenly stopped index rebuild script while running?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-20 : 22:25:02
|
| You shouldn't . It will rollback. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-06-21 : 06:30:08
|
| No , as sodeep said it will just rollback. If you are concerned about this situation , you could use the defrag , which won't rollback and will stop in place , if a situation arisesJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-21 : 09:39:25
|
| thankyou very much for clarification....actually i've run that on a 50Gb database which is up and running. per minute it on an average 1000 rows will be inserted. because it has taken around 20 min, i've stopped that. should i need to take db offline? or can i do while it is online?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-21 : 12:35:38
|
| Yes , you can do it online but your TempDB space should be high enough as it does its internal operation like snapshot of index, row-versioning ,sorting in TempDB. Online reindexing is allowed only in SQL 2005 enterprise edition. |
|
|
|
|
|
|
indexrebuild stopped unexpectedly