marg131 (12/1/2010)
yes, I just check recovery interval and it is 0. one thing i don't understand that only log size is grown crazy, but data size is no chnage basically. I tried to backup log with truncate_only, still no difference. is reportservertempDB is difference than others?thx, maggie
I have explained it in the first page read my posts again and talk to your developers find out why all the temp tables and table variables are needed and invest on design most employers don't provide the time for design.