Transaction Log in Sql Server -


for statements ddl or dml, transaction log maintained , why?

the transaction log used record information on each of transactions have occurred. can use able roll transactions, or in case of database recovery operation can restore backup , roll forward using recent transaction log files re-apply changes have been made database.

here helpful article talks in bit more detail.


Comments

Popular posts from this blog

WPF: binding viewmodel property of type DateTime to Calendar inside ItemsControl -

java - Getting corefrences with Standard corenlp package -

jQuery clickable div with working mailto link inside -