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 |
|
Vishal_sql
Posting Yak Master
102 Posts |
 Posted - 2012-08-03 : 04:26:25
|
| Hi All, I want to know What is risk of rebuilding index on Production.I heard it could get corrupted. Please provide some details on it.Thanks. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2012-08-03 : 05:19:17
|
| I don't know where you heard that. If you have Enterprise Edition you can do this and still have the index available for use, if you have Standard Edition, the Index you are rebuilding will be unavialble for the time it takes to build. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-08-04 : 11:50:53
|
| very little risk. For example, if during a index rebuild there was a physical component failure - this would not cause a logical failure (which is what I think you're talking about). If , you stopped the index rebuild in flight, this is handled logically. There have been some corruption bugs in the past - and there are some knowledge base articles outlining the problemJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
Vishal_sql
Posting Yak Master
102 Posts |
Posted - 2012-08-06 : 02:46:09
|
| Thanks Rick and Jack for your comments.As I have no experience in DB kind of task.And I had to Rebuild indexes on Production.I thought its good to know experienced persons view on it. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-08-06 : 07:28:06
|
| This is a good place to clear up myths and misconceptions about SQL Server:http://www.sqlskills.com/BLOGS/PAUL/category/Misconceptions.aspx |
|
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2012-08-06 : 11:29:08
|
| Why do you think you need to rebuild? |
|
|
|
|
|
|
Risk in rebuilding of indexes