Home Forums SQL Server 2008 T-SQL (SS2K8) How to manage Transaction Log. RE: How to manage Transaction Log.

  • July 31, 2012 at 2:25 pm

    #1519970

    george sibbald (7/31/2012)

    ALL transactions are logged, there is no way to prevent that. You will either have to size your transaction log so it can cope with the update or preferably batch the update up so it commits at regular intervals and therefore the committed transactions can be cleared from the log

    Thanks a lot, even i was thinking abt the same. But wanted to explore any optons whatsoever, i cannot change anything on database(no permissoins).