Maintenance Plan - Causes Log to Become Full

[JohnBates]

hello,

This is SQL Server 2005 SP2

For this database I have the max log size set to 14 GB (actual size of the data file is 32 GB) Until yesterday the log had never become full. The size was 2 GB before starting the Plan

I ran the same maint plan that runs every weekend but this time it filled up the t-log.

The Plan:
- reindexes tables and views
- changes free space to 10 %
- updates statistics
- updates usage

What could cause the t-log to fill up while the maint plan is running?

Thanks, John

 

[Crowley16]

do you do a log backup immediately before?

re-indexing tables and views will heavily use the logs, it may be worth while to do some sort of fragmentation test and only re-index those tables/views that need it.

Or break down the task into smaller ones with a log backup between each.

--------------------
Procrastinate Now!