Transaction Log : >> Transaction log is tracks transaction on that database. >> There should be at least one  transaction log (ldf) file for every database, >> Transaction log is always write in sequential manner , Only at redo state … Continue reading →