Index Maintanance Plan - with DR site log shipping ( Off site )
Posted on 2014-04-07
I have set up a Index Maintenance plan that runs every Sunday that is using Ola Hallengren's scripts. This works brilliantly except that it is increasing the LDf file ( which it does normally from Rebuilding index's where needed ) and for me to log ship this file would be 50 GB which if i had to do would take probably around 14 hours. I have also tried to use the "Sort In Tempdb" which i thought would use that instead but not still growing the LDF of database that is been indexed.
Can anyone please advise how i can keep log shipping going for this maintenance schedule, as i have to set up a agent job for DBCC SQLPERF (LOGSPACE) and DBCC SHRINKDATABASE then copy the database after a backup to DR site.