tips & tricks

Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

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...
Categoria: SQLServer
venerdì, 01 ago 2008 Ore. 15.07

Scrivi un commento

(l'indirizzo e-mail non verrà pubblicato, consente di essere avvertiti quando arrivano nuovi commenti a questo Post)


Autore: EdoInviato il: 05 lug 2011 - 11.09
Per ulteriori chiarimenti guardare qui:
Copyright © 2002-2007 - Blogs 2.0 | Home Page Blogs
ASP.NET 2.0 Windows 2003