Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Transaction log

Author  Topic 

Christina Agyeman
Starting Member

15 Posts

Posted - 2002-11-18 : 06:03:15
Does anyone know how to estimate how much the transaction log will grow after a update statement is performed.

I have a large table that contains 2 million record. The size of the table is 3027520 kb and index size is 11255728 kb. The row length is 250 bytes. I need to update 5 interger columns.

Does anyone know how I go about estimating the trnsaction log size need to perform this update.


   

- Advertisement -