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
Post a Comment