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

apache - Add omitted ? to URLs -

redirect - bbPress Forum - rewrite to wwww.mysite prohibits login -

php - How can I stop spam on my custom forum/blog? -