August 20, 2013 at 2:25 pm
I have to kill Index Rebuild process due to space issues, does this cause any corruption in database?
Thanks
August 20, 2013 at 2:26 pm
While anything is possible, No.
Is this a non-clustered index?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 20, 2013 at 2:30 pm
Yes Its a non clustered index.How can we avoid to increase the log growth.However, log backup is scheduled to run every 10 mins.
Thanks
August 20, 2013 at 2:39 pm
You can't govern the log file growth - this is a logged operation. How "wide" is the index? i.e. How many columns are in it and how many are in the include?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy