Home Forums SQL Server 2008 SQL Server 2008 Administration Rebuild Index Maintenance Job Running Long RE: Rebuild Index Maintenance Job Running Long
Rajeev Ramachandran
SSC Enthusiast
Points: 154
More actions
February 12, 2013 at 10:44 pm
#1587288
Did you change the Recovery Model? In FULL recovery model Index Rebuild takes long time due to logging of each and every page allocation.