InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 17:49:25 GMT20http://www.sqlservercentral.com/Forums/Topic885932-146-1.aspxyes, that goes without saying!Sat, 20 Mar 2010 04:16:30 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic885932-146-1.aspx[quote][b]Perry Whittle (3/19/2010)[/b][hr]it's also worth noting if the database is in simple or bulk-logged recovery the create\alter index is not fully logged![/quote]Minimally logged, but that doesn't change the 'no commit, no change' rule.Sat, 20 Mar 2010 03:57:35 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic885932-146-1.aspxAs Gail says "no commit, no dice" ;-)it's also worth noting if the database is in simple or bulk-logged recovery the create\alter index is not fully logged!Fri, 19 Mar 2010 18:27:43 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic885932-146-1.aspxThank you so much all for the reply! So it rolls back even for the job fails for some reason?Fri, 19 Mar 2010 09:33:22 GMThydbadrosehttp://www.sqlservercentral.com/Forums/Topic885932-146-1.aspxAs with any data modification, if the transaction is not committed and there's a server failure, the changes will all be rolled back as part of the database restart-recovery.Fri, 19 Mar 2010 03:36:25 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic885932-146-1.aspxPerry is correct, ACID property holds good here.Thu, 18 Mar 2010 16:12:07 GMTGTRhttp://www.sqlservercentral.com/Forums/Topic885932-146-1.aspxthe index which is being rebuilt is stored in a temporary area and brought in when the rebuild has finished to replace the existing index. An outage shouldnt really have any affect. The database consistency overall could be supsect but sql server takes care of this when starting up the database (using the transaction log file).Thu, 18 Mar 2010 16:07:26 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic885932-146-1.aspxPlease advise, when you rebuild indexes if suppose the job failed due to some reason such as power outage, etc., what happens to the indexes? Does it get wiped from database? Same question for update stat, what happens to statistics if during the execution if there is a power outage or job fails. Does the stats gets wiped from database? Please advise how it works. ThanksThu, 18 Mar 2010 15:01:52 GMThydbadrose