tips & tricks


Calendario
gennaio 2023
lmmgvsd
2627282930311
2345678
9101112131415
16171819202122
23242526272829
303112345

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
Archivio Posts
Anno 2020

Anno 2018

Anno 2015

Anno 2013

Anno 2011

Anno 2010

Anno 2009

Anno 2008
Statistiche
  • Views Home Page: 11.189
  • Views Posts: 55.078
  • Views Gallerie: 2.837
  • n° Posts: 120
  • n° Commenti: 1
Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003