Lutz,

Your query works as well. Since it seems more efficient I will use the query you specified instead.

Ryan

vallolet04, Thanks so much for your help. The query works perfect!

GilaMonster: Yes, I am using the normal maintenance plan.

Ten Centuries: That's it! The TRN backup takes the duration of the index rebuild. I know that because I end up with a 30GB TRN file during the...

GilaMonster: it does not backup up the TRN log during the index rebuild. I'll check the open transactions on the server this weekend.

Ten Centuries: No there is no full backup running at the time of the index rebuild.

GilaMonster: I am NOT backing up the log with NO_Truncate. The earlier post...

At this point I've concluded that I am going to have to leave the TRN log at its max size. I fall under the category of an accidental DBA...

Ok, I have attempted to backup the TRN file during the hours of the DB Maintenance Plan. I setup a DB Maint Plan that kicks off 15min before the...

Wow, great ideas. JimBama i'm still using SQL 2000. Thanks for the advice though. I'm going to try and setup that alert that George suggested.

Thanks!

Thanks for your help. I'm thinking I'll just try increasing the TRN backup frequency during the index rebuild to see if that helps for now.

Ok, I do want to create a custom script to switch the db to bulk_logged during index rebuilds. I started creating a script and if I should be posting...

I just noticed that maint plan also performs an optimization at the same time. It is set as follows:

Reorganize data and index pages.

Change free space per page percentage to...

I having trouble with my transaction log growth again. My maintenance plan backups up the TRN log every hour. During the busiest time of the day the hourly...

Gila,

I see what you are getting at. When I get the answer to what your asking, I'll be able to better judge what to set my Transaction Log size...

Gila,

I have one last question to get some closure on this subject. I ran a dbcc sqlperf(LogSpace) on my database and found that the Log Size is currently 30GB....