I have two SQL Server 2008 instances that are having issues with SQL Server Maintenance plans that "Rebuild" indexes on a weekly basis. The one instance has large databases over 100GB in size. The plan fails when it the lock time period is exceeded. I thought I would try the "online" rebuild.... but that is only available on "Enterprise" editions. I went through and was able to manually "Rebuild" all fragmented indexes. Is there a better way to do this?
On the other instance, when the weekly Index Rebuild Maintenance Plan runs... it cause the "LDF" file to get so large that it blows off the disc. Should I run "Backup Log" jobs at a close interval during the Rebuild to prevent this from occurring?