Transaction log file (.ldf)

Transaction log principlesWhenever a data update is made entries are added to the transaction log.It is not possible to prevent this as it is part of the way sql server maintains integrity - particularly during recovery.The transaction log is a circular file i.e. when the end is reached any free entries at the start will be used.This means that all being well the file will stay at a constant size as the current entry cycles round.The system maintains the MinLSN which is a pointer to the first ac 
Leggi tutto il post...