I have set-up a daily backup of database and 4 hr backup of transaction logs in our production machine. One particular day I noticed one transaction log to be as big as the backup file itself. Ours is an e-commerce application. And it never happened again. Is it common to see such logs ? Is there something I should check ? Thanks in advance.

-- Anonymous, May 04, 2000

Answers

Also wanted to add. Is there a recommended ratio of database size to transaction log size for OLTP/e-commerce applications ?

-- Anonymous, May 04, 2000

Rajesh,

I suspect that on the particular day that you ran a big query or an update on a large table.

I have used 25% of the database size as the initial transaction log size. Your mileage may vary.

Hope this helps,

Eric

-- Anonymous, May 09, 2000