• This is something what is being configured by Microsoft script best practice configuration. Depending on environment (hardware) we do create n number of temp databases. Also, we do 15 min tran log backup, and full database backup. Through our maintenance and best practice config we never had any issues with huge databases log files. Well, presume it is matter of experience. If I get a spec for the box, I could suggest some config options.

    ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*Brevity is the soul of wit.