April 16, 2015 at 7:43 am
Hi all,
My organization have log backups scheduled for every 30 minutes. We need to change the frequency to 5 or 10 minutes until reindex job gets complete(which is once a week).
I want to add an extra step in the job to change the log backups to small chunks ONLY until reindex is complete.
(current job steps step1:Reindex step2: checkdb)
Please advise.
April 16, 2015 at 8:13 am
Add a few steps to the job then. First, disable the standard log backups. Then, have a second log backup job that runs more frequently. Enable that. Run your process. At the end, swap the enabled/disabled on the two jobs. You should be good to go. Just make sure that both log backup jobs are writing to the same location. Technically, you can let both run, but for cleanliness, I'd turn one off before I turned the other on.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 16, 2015 at 3:27 pm
Be careful if you are using logshipping, you don't want to have log backups outside the jobs that are part of logshipping.
I would approach it differently, either build sp_start_job commands into your reindex loop to kick off your transaction log backup, or create a job on a 5 minute schedule which runs sp_start_job 'your_tranlog_backup' and enable\disable it at the beginning and end of the reindex.
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply