Transaction logs as big as backup : LUSENET : SQL Server Database Administration : One Thread

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


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


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,


-- Anonymous, May 09, 2000

Moderation questions? read the FAQ