index reorganised on f0911

adeel

VIP Member
I have SSIS package and what it does every night to take DB backup every night. Also within SSIS package i do alter index reorganized to all tables after backup done.
occassionaly the transaction log get full and eats all drive space. i looked the error log and found that fails on f0911 during alter index not sure it is the culprit. i have to shrink the transaction log even transaction log backup run every 30 min from other SSIS package
Note None of our user works middle of night during backup time and none if other job conflct except backup of drive ftom appassure.

I can read transaction log using fn_dblog but it is huge and lot of info.

Thought? may be i should not to index everyday but weekly best practice?

AD
 
Back
Top